- 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 - OBIEE Application Server helps to work on client components and Oracle provides Oracle10g Application server with OBIEE suite?
Answer : A
Q 2 - While creating a new repository, which of the following meta types you can import?
Answer : E
Explanation
Accept the meta types you want to import → You can select Tables, Keys, Foreign Keys, System tables, Synonyms, Alias, Views, etc.
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 - To open the Logical Table Source dialog box in BMM layer, you have to double click on?
Answer : A
Q 5 - Which of the following functions cant 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
Answer : C
Explanation
User has a logging level set to 0 and Administrator has a logging level set to 2.
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 can be used to create a new user in OBIEE?
Answer : B
Explanation
To create a new user, log on to the WebLogic Server admin console → Security Realms from the Fusion Middleware Control menu.