Oracle Business Intelligence Suite Enterprise Edition (OBIEE) Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Amehta
A
Amehta
Community Contributor
Quizzes Created: 3 | Total Attempts: 2,846
Questions: 18 | Attempts: 346

SettingsSettingsSettings
Oracle Quizzes & Trivia

Questions and Answers
  • 1. 

    Which of the following sections in PL-SQL Anonymous Block

    • A.

      Declare

    • B.

      Exception

    • C.

      Run

    Correct Answer(s)
    A. Declare
    B. Exception
    Explanation
    The correct answer is "Declare, Exception". In PL-SQL, an anonymous block starts with the DECLARE keyword, which is used to declare variables, constants, and cursors. The EXCEPTION section is used to handle any exceptions that may occur during the execution of the block. The RUN section is not a valid section in PL-SQL.

    Rate this question:

  • 2. 

    Which of the following are valid layers of a .rpd?

    • A.

      Physical

    • B.

      Cubical

    • C.

      Presentation

    Correct Answer(s)
    A. Physical
    C. Presentation
    Explanation
    The correct answer is Physical and Presentation. In the context of a .rpd file, the Physical layer represents the physical data sources and their structures, while the Presentation layer defines the business model and the way data is presented to users. The Cubical layer mentioned in the options is not a valid layer in a .rpd file.

    Rate this question:

  • 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

    Correct Answer
    A. NQSCONFIG.INI
    Explanation
    NQSCONFIG.INI is the correct answer because it is the file that specifies the current .rpd (Repository) to the BI Server. This file contains the configuration settings for the BI Server, including the location of the .rpd file. By specifying the .rpd file in the NQSCONFIG.INI file, the BI Server knows which repository to use for processing queries and delivering results. INSTANCECONFIG.XML is not the correct answer because it is a different configuration file that contains settings for the BI Server instance, such as port number and log file location. "None of the Above" is not the correct answer because NQSCONFIG.INI is the file that specifically specifies the .rpd file.

    Rate this question:

  • 4. 

    Calculation Measures can be created using :-

    • A.

      Logical Columns

    • B.

      Physical Columns

    • C.

      Hierarchy Levels

    Correct Answer(s)
    A. Logical Columns
    B. Physical Columns
    Explanation
    Calculation Measures can be created using logical columns and physical columns. Logical columns are derived from existing columns in a dataset and are based on logical operations or calculations. Physical columns, on the other hand, are actual columns in the dataset that can be used for calculations. By utilizing both logical and physical columns, users can create calculation measures that provide meaningful insights and analysis based on the data available.

    Rate this question:

  • 5. 

    It is possible to alter the sequence of columns within a table in the presentation Layer of .rpd ?

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In the presentation layer of .rpd, it is indeed possible to alter the sequence of columns within a table. This can be done to customize the way data is presented and organized in the user interface. By rearranging the sequence of columns, users can have a more convenient and intuitive view of the data.

    Rate this question:

  • 6. 

    When Using Answers we can create a Filter on a column which is not included in the criteria ?

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    When using Answers, it is possible to create a filter on a column that is not included in the criteria. This means that you can apply a filter to a column that is not being used as a condition in the query or analysis. This can be useful in situations where you want to further refine your data by applying additional filters based on other columns that are not part of the initial criteria.

    Rate this question:

  • 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

    Correct Answer
    A. Column Selector
    Explanation
    The Column Selector view allows you to see results by being able to substitute one or more of the columns at runtime with other columns chosen beforehand. This means that you can dynamically change the columns displayed in the view, giving you flexibility in analyzing and comparing different sets of data. The Row Selector and None of the Above views do not provide this functionality.

    Rate this question:

  • 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

    Correct Answer
    A. View Selector
    Explanation
    The View Selector allows you to see results by allowing you to change the view type at runtime. This means that you can easily switch between different views, such as a grid view or a chart view, to analyze and interpret the data in different ways. By using the View Selector, you have the flexibility to customize your view and gain insights from the data in a way that suits your needs.

    Rate this question:

  • 9. 

    Multiple Requests created by you can be viewed in a dashboard by adding them to the same ?

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    By adding multiple requests to the same dashboard, you can view all of them in one place. This allows for easy organization and monitoring of the requests you have created.

    Rate this question:

  • 10. 

    It is possible to exclude a column from your pivot table without removing it from the criteria ?

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Yes, it is possible to exclude a column from a pivot table without removing it from the criteria. This can be done by simply unchecking the box next to the column name in the pivot table field list. By doing this, the column will no longer be displayed in the pivot table, but it will still be included in the criteria for calculating the values in the table.

    Rate this question:

  • 11. 

    BI publisher report templates are made using MS-Word.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    BI publisher report templates are indeed made using MS-Word. MS-Word provides a user-friendly and familiar interface for creating and designing report templates. The templates created in MS-Word can then be uploaded and used in BI publisher to generate reports based on the data provided.

    Rate this question:

  • 12. 

    It is possible to do Add conditional formatting to reports made using Answers

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Conditional formatting allows users to apply formatting rules based on certain conditions or criteria. By using conditional formatting, users can highlight specific data or apply specific formatting styles to data that meet certain conditions. In Answers, it is possible to add conditional formatting to reports, which enables users to visually emphasize important information or trends based on specific criteria. Therefore, the given statement is true.

    Rate this question:

  • 13. 

    It's mandatory to create hierarchies for all dimension tables in the business layer of the .rpd

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Creating hierarchies for all dimension tables in the business layer of the .rpd is not mandatory. Hierarchies are used to organize and structure data in a dimensional model, but not all dimension tables may have hierarchies. It depends on the specific requirements and structure of the data model. Therefore, the correct answer is False.

    Rate this question:

  • 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

    Correct Answer(s)
    A. Creating Logical Column
    B. Complex Join
    Explanation
    In the business layer of the .rpd, creating a logical column is possible. This involves defining a new column that is not present in the physical data source but is derived from existing columns using calculations or expressions. Additionally, complex joins can also be performed in the business layer. These joins involve combining multiple tables or views using various join conditions and operators. Therefore, both creating logical columns and performing complex joins are valid actions that can be done in the business layer of the .rpd.

    Rate this question:

  • 15. 

    Where do you set the Logging level for a user?

    • A.

      BI Administration Tool

    • B.

      Answers

    • C.

      BI Publisher

    Correct Answer
    A. BI Administration Tool
    Explanation
    In the BI Administration Tool, you can set the logging level for a user. This tool allows administrators to manage and configure various settings for the BI system, including logging levels. By setting the logging level, administrators can control the amount of detail that is recorded in the system logs for a specific user. This can be useful for troubleshooting and monitoring user activity within the BI system.

    Rate this question:

  • 16. 

    "Column" is a valid column name for a table in Oracle

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In Oracle, "Column" is a valid column name for a table because Oracle allows column names to be any valid identifier, including keywords. Therefore, "Column" can be used as a column name without any issues.

    Rate this question:

  • 17. 

    Which character is used to continue a statement in SQL*Plus?  

    • A.

      - -

    • B.

      /

    • C.

      *

    Correct Answer
    A. - -
    Explanation
    The character used to continue a statement in SQL*Plus is the hyphen (-). This character is used to indicate that the statement is continued on the next line.

    Rate this question:

  • 18. 

    A BI publisher report can have more than one template associated with it.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In BI publisher, a report can have multiple templates associated with it. This allows users to generate the same report in different formats or layouts based on their requirements. Each template can have its own design and formatting options, allowing for flexibility in generating reports. Therefore, the statement "A BI publisher report can have more than one template associated with it" is true.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 04, 2011
    Quiz Created by
    Amehta
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.