Oracle Business Intelligence Suite Enterprise Edition (OBIEE) Quiz

18 Questions | By Amehta | Updated: Mar 20, 2022 | Attempts: 343

Questions

Settings

Create your own Quiz

Questions and Answers

1.

Which of the following sections in PL-SQL Anonymous Block
- A.
  
  Declare
- B.
  
  Exception
- C.
  
  Run
2.

Which of the following are valid layers of a .rpd?
- A.
  
  Physical
- B.
  
  Cubical
- C.
  
  Presentation
3.

Which of the following files specifies the current .rpd to the BI Server?
- A.
  
  NQSCONFIG.INI
- B.
  
  INSTANCECONFIG.XML
- C.
  
  None of the Above
4.

Calculation Measures can be created using :-
- A.
  
  Logical Columns
- B.
  
  Physical Columns
- C.
  
  Hierarchy Levels
5.

It is possible to alter the sequence of columns within a table in the presentation Layer of .rpd ?
- A.
  
  True
- B.
  
  False
6.

When Using Answers we can create a Filter on a column which is not included in the criteria ?
- A.
  
  True
- B.
  
  False
7.

Which view allows you to see results by being able to substitute one or more of the columns at runtime with other columns chosen beforehand ?
- A.
  
  Column Selector
- B.
  
  Row Selector
- C.
  
  None of the Above
8.

Which view allows you to see results by allowing you to change the view type at runtime ?
- A.
  
  View Selector
- B.
  
  Column Selector
- C.
  
  Both of the Above
9.

Multiple Requests created by you can be viewed in a dashboard by adding them to the same ?
- A.
  
  True
- B.
  
  False
10.

It is possible to exclude a column from your pivot table without removing it from the criteria ?
- A.
  
  True
- B.
  
  False
11.

BI publisher report templates are made using MS-Word.
- A.
  
  True
- B.
  
  False
12.

It is possible to do Add conditional formatting to reports made using Answers
- A.
  
  True
- B.
  
  False
13.

It's mandatory to create hierarchies for all dimension tables in the business layer of the .rpd
- A.
  
  True
- B.
  
  False
14.

Which of the following can be done in the business layer of the .rpd
- A.
  
  Creating Logical Column
- B.
  
  Complex Join
- C.
  
  None of the Above
15.

Where do you set the Logging level for a user?
- A.
  
  BI Administration Tool
- B.
  
  Answers
- C.
  
  BI Publisher
16.

"Column" is a valid column name for a table in Oracle
- A.
  
  True
- B.
  
  False
17.

Which character is used to continue a statement in SQL*Plus?
- A.
  
  - -
- B.
  
  /
- C.
  
  *
18.

A BI publisher report can have more than one template associated with it.
- A.
  
  True
- B.
  
  False