- 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 - In OBIEE architecture, Scheduler is part of which of the following component?
Answer : A
Explanation
OBIEE Server Components −
- Oracle BI (OBIEE) Server
- Oracle Presentation Server
- Application Server
- Scheduler
- Cluster Controller
Q 2 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?
Answer : B
Q 3 - Physical join is recommended to be used in?
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 - Dimensions where data changes rapidly are known as?
A - Slowly Changing Dimensions
Answer : A
Q 6 - The name of presentation columns are normally different from logical column names in the Business Model and Mapping layer?
Answer : B
Q 7 - You can disable the cache option from?
A - Capacity Management Tab of Fusion MiddleWare
B - Diagnostics Tab of Fusion MiddleWare
Answer : A
Explanation
In the left side, expand Business Intelligence → coreapplication → Capacity Management tab → Performance
Q 8 - Which of the following dimension hierarchies are possible in OBIEE?
A - Dimensions with level based hierarchies
Answer : C
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?
Answer : C
Explanation
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?
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