- 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 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 - Which of the following component types are responsible to run OBIEE system as compared to components used for creating interactive dashboards?
Answer : B
Explanation
Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.
Q 2 - Which of the following components are not managed in OBIEE repository?
Answer : B
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 - Logical and Complex joins are used in?
Answer : B
Explanation
Joins in this layer are Logical joins. It doesnt 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 - Dimensions where data changes rapidly are known as?
A - Slowly Changing Dimensions
Answer : A
Q 6 - Which of the following can be used for performance optimization when table size is too large?
Answer : C
Explanation
You can also define a table as driving table from drop down list in Joining Manager, this is used for performance optimization when table size is too large.
Q 7 - What does LBM stands for?
Answer : B
Q 8 - In the current version of OBIEE (11g), java component used is:
Answer : C
Q 9 - Which of the following tool enables end users to run ad-hoc reports and analysis as per business requirement model?
Answer : C
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.