- 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 stands for?
A - Oracle Business Intelligence Enterprise Edition
B - Oracle Business Intelligence Express Edition
Answer : A
Q 2 - Designing an OBIEE repository using administration tool is how many layer process?
Answer : B
Explanation
It is a three layer process- starting from Physical Layer (Schema Design), Business Model Layer, Presentation Layer.
Q 3 - Which of the following layer of OBIEE repository contains information about data sources and is responsible for importing metadata from databases?
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 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 - Which of the following is most suitable for cache management?
Answer : A
Q 8 - Which of the following dimension hierarchies are possible in OBIEE?
A - Dimensions with level based hierarchies
Answer : C
Q 9 - Session variables are similar to dynamic repository variables and that they obtain their values from initialization blocks?
Answer : A
Q 10 - If you are not able to view data of a Physical table, which of the following can be used?