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 2 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?

A -Oracle BI Java Host

B - OBIEE Repositories

C - BI Presentation Server

D - Oracle BI Server

Answer : B

Q 3 - It is recommended to use Physical join in physical layer and complex join in BMM layer as much as possible to keep Repository design simple. Only when there is an actual need for a different join, then use Physical join in BMM layer?

A - True

B - False

Answer : A

Q 4 - To open the Logical Table Source dialog box in BMM layer, you have to double click on?

A - Logical table source

B - Logical table

C - Both

Answer : A

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 Aggregate functions you can use?

A - Sum

B - Average

C - Count

D - Max

E - All of these

Answer : E


There are various Aggregate functions that can be used like Sum, Average, Count, Max, Min, etc.

Q 7 - What is the extension of Repository file?

A - .RXD

B - .RCD

C - .RPD

D - .RLD

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 tool enables end users to run ad-hoc reports and analysis as per business requirement model?

A - Column prompt

B - Variable prompt

C - OBIEE Dashboard

D - Presentation Layer

Answer : C

Q 10 - Which of the following is most recommended way of assigning permissions and privileges?

A - Application Roles

B - Individual Users

C - Catalog Groups

D - All of the above

Answer : A


To application roles − Most recommended way of assigning permissions and privileges.

To individual users − This is difficult to manage where you can assign permissions and privileges to specific users.

To Catalog groups − It was used in previous releases for backward compatibility maintenance.