- 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 - In OBIEE architecture, Scheduler is part of which of the following component?
Answer : A
Explanation
OBIEE Server Components −
- Oracle BI (OBIEE) Server
- Oracle Presentation Server
- Application Server
- Scheduler
- Cluster Controller
Q 2 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?
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 - Dimensions derived from fact table and doesnt include in dimension table are known as?
Answer : C
Q 5 - When you drag the tables from Physical layer to BMM layer, it also preserves the joins and keys automatically?
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 7 - Which of the following is most suitable for cache management?
Answer : A
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 tool enables end users to run ad-hoc reports and analysis as per business requirement model?
Answer : C
Q 10 - Which of the following Prompts enables you to build very specific value prompts to either stand alone on the dashboard or analysis or to expand or refine existing dashboard and analysis filters?
Answer : C
Explanation
A column prompt is the most common and flexible prompt type. A column prompt enables you to build very specific value prompts to either stand alone on the dashboard or analysis or to expand or refine existing dashboard and analysis filters. Column prompts can be created for hierarchical, measure, or attribute columns at the analysis or dashboard level.