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 2 - While creating a new repository, which of the following meta types you can import?

A - Foreign Keys

B - System tables

C - Synonyms

D - Alias

E - All of the above

Answer : E

Explanation

Accept the meta types you want to import → You can select Tables, Keys, Foreign Keys, System tables, Synonyms, Alias, Views, etc.

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

Answer : D

Explanation

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.

Answer : A

Explanation

Presentation Column dialog box appears → to use the name of the logical column, select the Use Logical Column check box.

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 - How many types of Repository variables you can create?

A - 1

B - 2

C - 3

D - 4

E - 5

Answer : B

Explanation

There are two types of Repository variables −

  • Static Repository Variables
  • Dynamic Repository Variables

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