- OBIEE Tutorial
- OBIEE - Home
- OBIEE - Data Warehouse
- OBIEE - Dimensional Modeling
- OBIEE - Schema
- OBIEE - Basics
- OBIEE - Components
- OBIEE - Architecture
- OBIEE - Repositories
- OBIEE - Business Layer
- OBIEE - Presentation Layer
- OBIEE - Testing Repository
- OBIEE - Multiple Logical Table
- OBIEE - Calculation Measures
- OBIEE - Dimension Hierarchies
- OBIEE - Level-Based Measures
- OBIEE - Aggregates
- OBIEE - Variables
- OBIEE - Dashboards
- OBIEE - Filters
- OBIEE - Views
- OBIEE - Prompts
- OBIEE - Security
- OBIEE - Administration
- OBIEE Useful Resources
- OBIEE - Questions Answers
- OBIEE - Quick Guide
- OBIEE - Useful Resources
- OBIEE - Discussion
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
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?
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?
Answer : A
Q 4 - Which of the following statement is incorrect about foreign keys in Physical layer?
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 - Which of the following is faster method of creating Logical tables/objects in BMM layer?
A - Dragging Physical tables to Business Model
Answer : A
Explanation
Dragging Physical tables to Business Model which is the fastest way of defining Logical tables.
Q 6 - Which of the following Aggregate functions you can use?
Answer : E
Explanation
There are various Aggregate functions that can be used like Sum, Average, Count, Max, Min, etc.
Q 7 - What does LBM stands for?
Answer : B
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?
Answer : B
Explanation
Level 0 means no logging and Level 5 means maximum logging level information.
Q 9 - Session variables are similar to dynamic repository variables and that they obtain their values from initialization blocks?
Answer : A
Q 10 - Which of the following is most recommended way of assigning permissions and privileges?
Answer : A
Explanation
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.
To Continue Learning Please Login
Login with Google