- 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 - 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 - Physical layer in OBIEE supports single data source in a single repository and you need to create multiple repositories to use multiple data sources?
Answer : A
Explanation
Physical layer in OBIEE supports multiple data sources in a single repository - i.e. data sets from 2 different data sources can be performed in OBIEE.
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 functions can’t be performed in Presentation layer?
Answer : D
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 - Which of the following dimension hierarchies are possible in OBIEE?
A - Dimensions with level based hierarchies
Answer : C
Q 9 - Which of the following Variable type has a single value at any point of time and are defined using Oracle BI Administration tool?
Answer : A
Explanation
A Repository variable has a single value at any point of time. Repository variables are defined using Oracle BI Administration tool. Repository variables can be used in place of constants in Expression Builder Wizard.
Q 10 - Suppose that an analysis contains the sales totals for a certain region of US in US dollars. However, because the users viewing the analysis reside in the Canada, they want to view data in CAD. Which of the following feature helps?
To Continue Learning Please Login
Login with Google