0
Alien head

platforms and products Online Quiz - 51

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

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

  1. True

  2. False

Answer: 2

Which type of variable does not need any initialization block.

  1. Static

  2. Dynamic

  3. System Session

  4. Non-System Session

Answer: 1

OBI repository supports column level security.

  1. True

  2. False

Answer: 1

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

  1. True

  2. False

Answer: 2

One logical column can have more than one logical source.

  1. True

  2. False

Answer: 1

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

  1. True

  2. False

Answer: 1

The maximum length of VARCHAR variable is -

  1. 1000000

  2. 10000000

  3. 100000000

  4. 1000000000

Answer: 3

Which is not a valid data type in OBI EE.

  1. BIT

  2. TINYUNIT

  3. UNIT

  4. LONGUNIT

Answer: 4

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.

Answer: 2

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

Answer: 4

All joins in the physical layer should be complex joins.

  1. True

  2. False

Answer: 2

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

  1. True

  2. False

Answer: 1

Physical layer of repository must contain a star schema.

  1. True

  2. False

Answer: 2

One server can create maximum 50 database connections.

  1. True

  2. False

Answer: 2

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

  1. True

  2. False

Answer: 2

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

  1. True

  2. False

Answer: 1

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

  1. True

  2. False

Answer: 1

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

  1. TCP

  2. UDP

  3. SAWTCP

  4. HTTP

Answer: 3

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

  1. True

  2. False

Answer: 2

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

  1. True

  2. False

Answer: 1
+ View questions