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 - Which of the following component types are responsible to run OBIEE system as compared to components used for creating interactive dashboards?

A - Client Components

B - Server Components

C - Business Layer components

D - All of the above

Answer : B

Explanation

Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.

Q 2 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?

A -Oracle BI Java Host

B - OBIEE Repositories

C - BI Presentation Server

D - Oracle BI Server

Answer : B

Q 3 - Physical join is recommended to be used in?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : A

Q 4 - To open the Logical Table Source dialog box in BMM layer, you have to double click on?

A - Logical table source

B - Logical table

C - Both

Answer : A

Q 5 - 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 6 - The name of presentation columns are normally different from logical column names in the Business Model and Mapping layer?

A - True

B - False

Answer : B

Q 7 - What is the extension of Repository file?

Answer : C

Q 8 - Which of the following dimension hierarchies are possible in OBIEE?

A - Dimensions with level based hierarchies

B - Dimension with Parent-child hierarchies

C - Both

Answer : C

Q 9 - Which of the following Variable type has a single value at any point of time and are defined using Oracle BI Administration tool?

A - Repository Variable

B - Session Variable

C - Request Variables

D - None of these

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.

Q 10 - 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

obiee_questions_answers.htm