OBIEE MCQ

1-      Which of them is/are not OBIEE Services to be started?

a)      Java Host

b)      Server

c)       Presentation

d)      Cache

2-      Which of them is/are not managed in Repository?

a)      Jobs

b)      Joins

c)       Catalog

d)      Variables

3-      Which of the Tools Utilities is not valid?

a)      LTS Column / Table Replacement

b)      Externalize String

c)       Updating Row Count

d)      Repository Documentation

4-      Which guided navigation type always appears on the Dashboard?

a)        Static links

b)        Static sections

c)        Conditional links

d)        Conditional sections

5-      Which of the Statement is/are incorrect:

a)      Repository Import to be activated from utilities

b)      Query Repository available in tools

c)       Projects to be allotted for MultiUser Development

d)      All are correct

6-   Which of the following is NOT true of the Business Model and Mapping layer?
a)      It determines what physical tables/columns can be used to satisfy queries

b)      It includes Connection Pool object and Schema folders

c)      It is where aggregation rules for measures are set

d)      It is where hierarchies are established

7-      This is/are a dimension where data changes rapidly

a)      Rapidly Changing Dimension

b)      Slowly Changing Dimension

c)      Junk Dimension

d)     Degenerate Dimension

8-      Dimension that is/are derived from fact table and does not have its own dimension table

a)      Rapidly Changing Dimension

b)      Slowly Changing Dimension

c)       Junk Dimension

d)      Degenerate Dimension

9 Which statements are TRUE of Filters? Choose two.
a) Filters are applied on a column-level basis.

b) Table level filters prompts can be added to a request.

c) Saved requests may be used as filters.

d) The SQL within a specific request cannot be edited.

10-   Request 1 returns Customers with Dollars between 5000 and 10000. Request 2 returns Customers with Dollars between 7000 and 20000. A union of these two requests should produce which of set of results?

a) Customers with Dollars between 5000 and 20000 plus duplication of Customers with Dollars
between 7000 and 10000

b) Customers with Dollars between 5000 and 20000

c) Customers with Dollars between 7000 and 20000

d) Customers with Dollars between 5000 and 7000

11-   Which of them is/are not Time Series Function?

a)      Ago()

b)      Todate()

c)       Period()

d)      PeriodRolling()

12-   What cannot be done in presentation layer of Repository?

a)      Nesting of folders

b)      Set implicit fact column

c)       Permission grant to groups/users for security

d)      Performing calculations of measures

13-   We can set Bridge table from

a)      Properties of Physical Tables

b)      Properties of Logical Table

c)       Properties of LTS

d)      Properties of Presentation Table

14. ABC would like to analyze which of its hundred stores have improved its order fulfillment rate last year. If ABC uses a dimensional modeling to answer the above question, which of the following would be its fact table?

a) Stores

b) Orders

c) Products

d) Time

15-   Which of the following is NOT true of a star schema?

a) The facts are quantifiable

b) The fact table has several foreign key columns composed of the primary keys of the related
dimensional tables

c) A fact table is linked to related dimension tables

d) Dimension tables are normalized

e) Dimension tables usually have a one-attribute primary key such as Product ID for Products

16-   Which of these is not Hierarchy type?

a)      Skipped Hierarchy

b)      Composite Hierarchy

c)       Parent Child Hierarchy

d)      Ragged Hierarchy

17-   Cache can be disabled from?

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

18-   Repository can be uploaded/ updated from?

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

19-   Log messages can be verified from?

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

20-   You can start all BI services of fusion middleware from:

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

21-   Calculations in logical columns are performed from which tab of logical tables?

a)      General Tab

b)      Column Source

c)       Aggregation Tab

d)      Levels Tab

22-   Which of the following stores content created by OBIEE Answers requests, filters, Siebel Intelligence Dashboards Pages, and the iBots?

a) Cascading Style Sheets

b) Repository file

c) Web catalog

d) Alerts

23-   In the current version of OBIEE (11g), java component used is:

a)      rcu

b)      oc4j

c)       Fusion Middleware

d)      Web logic server

24-   If you cannot view data of some physical table you should:

a)      Uncache the table

b)      Alias the table

c)       Update connection pool properties

d)      All of the above

25-   Which statement is true?

a)      If presentation column is renamed, logical column will get auto renamed

b)      If presentation column is renamed, physical column will get auto renamed

c)       If Logical column is renamed, presentation column will get auto renamed

d)      If Logical column is renamed, physical column will get auto renamed

26-      Other than Adhoc reporting & dashboards, what other features (for creating) are possible in recent version of obiee?

a)      Published Reporting

b)      Disconnected Analytics

c)       Actionable Intelligence

d)      Marketing

27-      Default Layout of adhoc report in results tab is?

a)      Title & Table View

b)      Table View

c)       Title & Pivot View

d)      Chart Pivoted view

28-      You can assign Administration & management rights to users / groups for answers/ dashboards or more products from?

a)      Manage Sessions

b)      Manage Interactive Dashboard

c)       Manage Privilege

d)      Manage Presentation catalog group or users

29-      Which Filter Operator is not valid type?

a)      Is blank

b)      Contains any

c)       Is in top

d)      Is in bottom

30-      Default Dashboard is set from?

a)      Administration

b)      My Account

c)       Dillivers

d)      BI Publisher

31-      How you can display two separate reports in same section to appear parallel.

a)      By Guided Navigation

b)      By Arranging Horizontally

c)       By Collapsible

d)      By Formatting Section

32-      Which of the following is not Dashboard object?

a)      BI Publisher Report

b)      Briefing Book Nav. Link

c)       Marketing

d)      Embedded Content

33-      Which is not valid type of set operation for combine with similar request?

a)      Union

b)      Intersect

c)       Minus

d)      SubSet

34-   Invalid Report View Type?

a)      Logical SQL

b)      Guided Result

c)       Create Segment

d)      Create Target List

35.   Localization (Language Preferance Setting) of dashboard is possible by?

a)      Administration

b)      My Account

c)       Login

d)      Dashboard

36-   How can you show updated changes made to online rpd, without restarting BI Services?

a)      Restart Java Host Services (Weblogic / oc4j)

b)      Reload EPT

c)       Reload Server Metadata

d)      Refresh Display

37-   How can you merge two separate reports from different subject area.

a)      Adding both reports in dashboard in same section.

b)      Clubbing two reports by OR logic

c)       By Combine with Similar Request Operation

d)      By Updating Request XML of Advanced Tab.

38-   If you successfully update any report in development environment, how you can generate same report with similar properties easily?

a)      By Pasting Request XML & SQL Issued from dev Advanced Tab to Prod / QA Advanced Tab.

b)      By creating report & updating all required functions/ filters from criteria tab.

c)       By Replacing prod / qa attribute files to dev atr files.

d)      Simply copying Request XML data from Dev & pasting to prod / qa.

39-   If you want to create any column (in criteria tab) based on certain calculation, you should:

a)      Use Filter option

b)      Use Function Option

c)       Use Column Format Option

d)      Use Sorting Option

40-   If you want to limit / restrict data based on some dimension attribute, you should:

a)      Use Filter option

b)      Use Function Option

c)       Use Column Format Option

d)      Use Sorting Option

41-   How can you update your date type dimension column to custom format (format of your choice).

a)      Use Filter option

b)      Use Function Option

c)       Use Column Properties Option

d)      Use Sorting Option

42-   How can you hide your criteria column?

a)      Use Filter option

b)      Use Function Option

c)       Use Column Properties Option

d)      Use Sorting Option

43-   How can you group by your column data:

a)      Use Filter option

b)      Use Function Option

c)       Use Column Properties Option

d)      Use Sorting Option

44.   Bins created in function are similar to:

a)      Case Statement of Expression Function

b)      Cast Statement of Conversion Function

c)       Count Statement of Aggregate Function

d)      RCount of Running Aggregate Function

45-   Which is not valid filter variable

a)      Session

b)      Repository

c)       Presentation

d)      Request