- 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 - 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 doesn’t 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 - Cardinality relation one to many means?
A - Each row in first logical dimension table there are 0, 1, many rows in second logical table.
B - Each row in first logical dimension table there are many rows in second logical table.
C - Each row in first logical dimension table there is 1 row in second logical table.
D - Many row in first logical dimension table there are 0, 1, many rows in second logical table.
Answer : A
Q 6 - In Presentation Column dialog box, you can use check box Use Logical Column name?
A - To use the name of the logical column
B - To specify a name that is different name
Answer : A
Explanation
Presentation Column dialog box appears → to use the name of the logical column, select the Use Logical Column check box.
Q 8 - Logging level can have values starting from Level 0 to level 5 and Level 0 means maximum logging and Level 5 means no logging level information?
Answer : B
Explanation
Level 0 means no logging and Level 5 means maximum logging level information.
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 - If you are not able to view data of a Physical table, which of the following can be used?
To Continue Learning Please Login