- 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 join is recommended to be used in?
Answer : A
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 cant be performed in Presentation layer?
Answer : D
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 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.