OBIEE Online Quiz


Following quiz provides Multiple Choice Questions (MCQs) related to OBIEE. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Q 1 - In OBIEE architecture, Scheduler is part of which of the following component?

A - Server Components

B - Client Components

C - Business Layer Components

D - All of the above

Answer : A


OBIEE Server Components −

  • Oracle BI (OBIEE) Server
  • Oracle Presentation Server
  • Application Server
  • Scheduler
  • Cluster Controller

Q 2 - Which of the following components are not managed in OBIEE repository?

A - Jobs

B - Catalog

C - Variables

D - Keys

Answer : B

Q 3 - Which of the following doesn’t represent a measure column in table?

A - Additive

B - Semi-additive

C - Count-additive

D - Non-additive

Answer : D

Answer : D


When you import tables from schema into RPD Physical Layer, You can also select KEY and FOREIGN KEY along with the table data, then the primary key-foreign key joins are automatically defined, however it is not recommended from performance point of view.

Q 5 - When you drag the tables from Physical layer to BMM layer, it also preserves the joins and keys automatically?

A - True

B - False

Answer : A

Q 6 - Which of the following should be used to overcome the issue of changing dimensions performance?

A - Junk Dimension

B - Degenerate Dimension

C - Mini Dimension

D - None of these

Answer : C

Q 8 - In a normal scenario, what is the logging level for Administrators?

A - 0

B - 1

C - 2

D - 3

Answer : C


User has a logging level set to 0 and Administrator has a logging level set to 2.

Q 9 - How many types of Repository variables you can create?

A - 1

B - 2

C - 3

D - 4

E - 5

Answer : B


There are two types of Repository variables −

  • Static Repository Variables
  • Dynamic Repository Variables

Q 10 - If you are not able to view data of a Physical table, which of the following can be used?

A - Uncache the table

B - Alias the table

C - Update connection pool properties

D - All of the above

Answer : C