Oracle Business Intelligence Suite Enterprise Edition (OBIEE) Quiz

18 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

.


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