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 - Designing an OBIEE repository using administration tool is how many layer process?

A - 2

B - 3

C - 4

D - 5

Answer : B


It is a three layer process- starting from Physical Layer (Schema Design), Business Model Layer, Presentation Layer.

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

Q 4 - Dimensions derived from fact table and doesn’t include in dimension table are known as?

A - Slowly Changing Dimension

B - Rapidly changing Dimension

C - Degenerate Dimension

D - None of these

Answer : C

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 can be used for performance optimization when table size is too large?

A - Logical Joins

B - Sub Query

C - Derived Table

D - Complex Joins

Answer : C


You can also define a table as driving table from drop down list in Joining Manager, this is used for performance optimization when table size is too large.

Q 7 - To improve query performance, BI server cache option should be?

A - Enabled

B - Disabled

C - Doesn’t Matter

Answer : B


To improve query performance, we disable BI server cache option

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

A - 0

B - 1

C - 2

D - 3

Answer : A

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 - Suppose that an analysis contains the sales totals for a certain region of US in US dollars. However, because the users viewing the analysis reside in the Canada, they want to view data in CAD. Which of the following feature helps?

A - Image Prompt

B - Variable Prompt

C - Currency Prompt

D - Column Prompt

Answer : C