Oracle Business Intelligence Suite Enterprise Edition (OBIEE) Quiz
18 Questions
Settings
-
+
.
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
Back to top