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.

Q 1 - OBIEE stands for?

A - Oracle Business Intelligence Enterprise Edition

B - Oracle Business Intelligence Express Edition

C - Oracle Business Interactive Enterprise Edition

D - Oracle Business Intelligence Enterprise Express

Answer : A

Q 2 - In OBIEE architecture, which of the following component is used to star and stop all components of BI system and is managed and controlled by Fusion Middleware Controller?

A - Web Logic Server

B - Node Manager

C - Oracle Process Manager and Notification Server

D - None of these

Answer : C

Explanation

Oracle Process Manager and Notification Server (OPMN) −

OPMN is used to star and stop all components of BI system. It is managed and controlled by Fusion Middleware Controller.

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 - Which of the following statement is incorrect about foreign keys in Physical layer?

A - A Foreign key in Physical layer is used to define Primary key-Foreign key relation between two tables.

B - When you create it in the physical diagram, you have to point first the dimension and then the fact table.

C - When you import tables from schema into RPD Physical Layer, You can also select KEY and FOREIGN KEY along with the table data.

D - When primary key-foreign key joins are automatically defined, It is recommended from performance point of view.

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.

Q 5 - Cardinality relation one to many means?

A - Each row in first logical dimension table there are 0, 1, many rows in second logical table.

B - Each row in first logical dimension table there are many rows in second logical table.

C - Each row in first logical dimension table there is 1 row in second logical table.

D - Many row in first logical dimension table there are 0, 1, many rows in second logical table.