- 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
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 I
Q 1 - OBIEE stands for?
A - Oracle Business Intelligence Enterprise Edition
B - Oracle Business Intelligence Express Edition
Answer : A
Q 2 - 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 3 - 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 4 - Which of the following component takes the request from users via browser and pass all requests to OBIEE server?
Answer : A
Explanation
OBIEE Presentation Server
It takes the request from users via browser and pass all requests to OBIEE server.
Q 5 - OBIEE Application Server helps to work on client components and Oracle provides Oracle10g Application server with OBIEE suite?
Answer : A
Q 6 - In OBIEE architecture, which of the following component is used to star and stop all components of BI system and is managed and controlled by Fusion Middleware Controller?
Answer : C
Explanation
Oracle Process Manager and Notification Server (OPMN) −
OPMN is used to star and stop all components of BI system. It is managed and controlled by Fusion Middleware Controller.
Q 7 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?
Answer : B
Q 8 - 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 9 - 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 10 - Which of the following components are not managed in OBIEE repository?
Answer : B
Q 11 - Which of the following doesn’t represent a measure column in table?
Answer : D
Q 12 - Physical join is recommended to be used in?
Answer : A
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | A |
| 2 | B |
| 3 | A |
| 4 | A |
| 5 | A |
| 6 | C |
| 7 | B |
| 8 | B |
| 9 | E |
| 10 | B |
| 11 | D |
| 12 | A |