- 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 Mock Test
This section presents you various set of Mock Tests related to OBIEE. You can download these sample mock tests at your local machine and solve offline at your convenience. Every mock test is supplied with a mock test key to let you verify the final score and grade yourself.
OBIEE Mock Test IV
Q 1 - 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 2 - In the current version of OBIEE (11g), java component used is:
Answer : C
Q 3 - Which of the following dimension hierarchies are possible in OBIEE?
A - Dimensions with level based hierarchies
Answer : C
Q 4 - 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 5 - 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.
Answer : B
Explanation
There are two types of Repository variables −
- Static Repository Variables
- Dynamic Repository Variables
Q 7 - Session variables are similar to dynamic repository variables and that they obtain their values from initialization blocks?
Answer : A
Q 8 - Which of the following tool enables end users to run ad-hoc reports and analysis as per business requirement model?
Answer : C
Q 9 - 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.
Q 10 - If you are not able to view data of a Physical table, which of the following can be used?
Answer : C
Q 11 - Which of the following is most recommended way of assigning permissions and privileges?
Answer : A
Explanation
To application roles − Most recommended way of assigning permissions and privileges.
To individual users − This is difficult to manage where you can assign permissions and privileges to specific users.
To Catalog groups − It was used in previous releases for backward compatibility maintenance.
Q 12 - Suppose that an analysis contains the sales totals for a certain region of US in US dollars. However, because the users viewing the analysis reside in the Canada, they want to view data in CAD. Which of the following feature helps?
Answer : C
Q 13 - 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.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | B |
| 2 | C |
| 3 | C |
| 4 | C |
| 5 | A |
| 6 | B |
| 7 | A |
| 8 | C |
| 9 | C |
| 10 | C |
| 11 | A |
| 12 | C |
| 13 | B |