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?
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?
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 - Physical join is recommended to be used in?
Q 4 - Logical and Complex joins are used in?
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 - Cardinality relation one to many means?
Q 6 - Which of the following should be used to overcome the issue of changing dimensions performance?
Q 7 - Which of the following is most suitable for cache management?
Q 8 - Logging level can have values starting from Level 0 to level 5 and Level 0 means maximum logging and Level 5 means no logging level information?
Level 0 means no logging and Level 5 means maximum logging level information.
Q 9 - Which of the following are used for query performance optimization while running the reports and eliminates the time taken by query to run the calculations and delivers the results at fast speed?
Aggregations are used to implement query performance optimization while running the reports. This eliminates the time taken by query to run the calculations and delivers the results at fast speed. Aggregate tables has less number of rows as compared to a normal table.
Q 10 - Which of the following is most recommended way of assigning permissions and privileges?
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.