- 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 III
Q 1 - 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 2 - Which of the following can be used for performance optimization when table size is too large?
Answer : C
Explanation
You can also define a table as driving table from drop down list in Joining Manager, this is used for performance optimization when table size is too large.
Q 3 - 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 4 - Which of the following should be used to overcome the issue of changing dimensions performance?
Answer : C
Q 5 - The name of presentation columns are normally different from logical column names in the Business Model and Mapping layer?
Answer : B
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
Q 8 - To improve query performance, BI server cache option should be?
Answer : B
Explanation
To improve query performance, we disable BI server cache option
Q 9 - You can disable the cache option from?
A - Capacity Management Tab of Fusion MiddleWare
B - Diagnostics Tab of Fusion MiddleWare
Answer : A
Explanation
In the left side, expand Business Intelligence → coreapplication → Capacity Management tab → Performance
Q 10 - What does LBM stands for?
Answer : B
Answer : A
Answer : C
Explanation
User has a logging level set to 0 and Administrator has a logging level set to 2.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | A |
| 2 | C |
| 3 | E |
| 4 | C |
| 5 | B |
| 6 | A |
| 7 | A |
| 8 | B |
| 9 | A |
| 10 | B |
| 11 | C |
| 12 | A |
| 13 | C |