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