Question 1

"OBI EE Server can host more than one repository files." True/False

technology platforms and products

True
False

Answer

Correct Option: A

Question 2

"Oracle BI Cluster controller can control BI Presentation Services to balance request load." True/False

technology platforms and products

True
False

Answer

Correct Option: B

Question 3

Which communication protocol is used by "analytics" plug in to communicate with the "BI Presentation Service"?

technology platforms and products

TCP
UDP
SAWTCP
HTTP

Answer

Correct Option: C

Question 4

"HashUserHomeDirectories is need to be set to > 2 so that more than 4000 can access OBI presentation catalog".

technology platforms and products

True
False

Answer

Correct Option: A

Question 5

One connection pool can connect to more than one database schema of the same database.

technology platforms and products

True
False

Answer

Correct Option: A

Question 6

Oracle BI Repository can support Oracle Long Objects (LOB, BLOB, CLOB etc).

technology platforms and products

True
False

Answer

Correct Option: B

Question 7

One server can create maximum 50 database connections.

technology platforms and products

True
False

Answer

Correct Option: B

Question 8

Physical layer of repository must contain a star schema.

technology platforms and products

True
False

Answer

Correct Option: B

Question 9

BMM layer should always contain a Star Schema or Dimensional Data Model.

technology platforms and products

True
False

Answer

Correct Option: A

Question 10

All joins in the physical layer should be complex joins.

technology platforms and products

True
False

Answer

Correct Option: B

Question 11

A complex join is -

technology platforms and products

Primary Key Foreign Key Join
Primary Key Candidate Key Join
Candidate Key Foreign KeyJoin
None of the above

Answer

Correct Option: D

Question 12

Select the statement which is False.

technology platforms and products

Number of element to Grand Total Level is 1
Number of element to Grand Total Level is greater than 1
All Level Should have a key
Final level of all the hierarchies should be same child level.

Answer

Correct Option: B

Question 13

Which is not a valid data type in OBI EE.

technology platforms and products

BIT
TINYUNIT
UNIT
LONGUNIT

Answer

Correct Option: D

Question 14

The maximum length of VARCHAR variable is -

technology platforms and products

1000000
10000000
100000000
1000000000

Answer

Correct Option: C

Question 15

One physical table can have more than one Alias with different primary key.

technology platforms and products

True
False

Answer

Correct Option: A

Question 16

One logical column can have more than one logical source.

technology platforms and products

True
False

Answer

Correct Option: A

Question 17

One presentation catalog can map to more than one business model.

technology platforms and products

True
False

Answer

Correct Option: B

Question 18

OBI repository supports column level security.

technology platforms and products

True
False

Answer

Correct Option: A

Question 19

Which type of variable does not need any initialization block.

technology platforms and products

Static
Dynamic
System Session
Non-System Session

Answer

Correct Option: A

Question 20

One presentation catalog can connect to as many repository as needed.

technology platforms and products

True
False

Answer

Correct Option: B

Description: platforms and products Online Quiz - 51
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: platforms and products

platforms and products Online Quiz - 51

Find more quizzes from top tags