0

platforms and products Online Quiz - 51

Description: platforms and products Online Quiz - 51
Number of Questions: 20
Created by:
Tags: platforms and products
Attempted 0/20 Correct 0 Score 0

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: B

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

  1. TCP

  2. UDP

  3. SAWTCP

  4. HTTP


Correct Option: C

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: B

One server can create maximum 50 database connections.

  1. True

  2. False


Correct Option: B

Physical layer of repository must contain a star schema.

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: A

All joins in the physical layer should be complex joins.

  1. True

  2. False


Correct Option: B

A complex join is -

  1. Primary Key Foreign Key Join

  2. Primary Key Candidate Key Join

  3. Candidate Key Foreign KeyJoin

  4. None of the above


Correct Option: D

Select the statement which is False.

  1. Number of element to Grand Total Level is 1

  2. Number of element to Grand Total Level is greater than 1

  3. All Level Should have a key

  4. Final level of all the hierarchies should be same child level.


Correct Option: B

Which is not a valid data type in OBI EE.

  1. BIT

  2. TINYUNIT

  3. UNIT

  4. LONGUNIT


Correct Option: D

The maximum length of VARCHAR variable is -

  1. 1000000

  2. 10000000

  3. 100000000

  4. 1000000000


Correct Option: C

One logical column can have more than one logical source.

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B
- Hide questions