OBIEE Online Quiz


Advertisements

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

Explanation

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 - Physical join is recommended to be used in?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : A

Q 4 - Logical and Complex joins are used in?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : B

Explanation

Joins in this layer are Logical joins. It doesn’t show expressions and tells the type of join between tables. It helps Oracle BI Server to understand the relationships between the various pieces of the business model.

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 the current version of OBIEE (11g), java component used is:

A - oc4j

B - Fusion Middleware

C - Weblogic server

D - None of these

Answer : C

Q 9 - Which of the following Variable type has a single value at any point of time and are defined using Oracle BI Administration tool?

A - Repository Variable

B - Session Variable

C - Request Variables

D - None of these

Answer : A

Explanation

A Repository variable has a single value at any point of time. Repository variables are defined using Oracle BI Administration tool. Repository variables can be used in place of constants in Expression Builder Wizard.

Q 10 - Which of the following can be used to create a new user in OBIEE?

A - Repository

B - WebLogic Server Admin console

C - OBIEE Dashboard

D - Scheduler

Answer : B

Explanation

To create a new user, log on to the WebLogic Server admin console → Security Realms from the Fusion Middleware Control menu.

obiee_questions_answers.htm
Advertisements