OBIEE 12C/OBIEE 12C Mcq Question Set 2 Sample Test,Sample questions

Question:
.............. is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.

1. Data Mining

2.Data Warehousing

3.Document Mining

4.Text Mining


Question:
A lookup transformation is used to look up data in

1.flat file

2.Relational table (wrong)

3.view

4.All of the above


Question:
An ......... system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

1.OLAP

2.OLTP

3.Both of the above

4. None of the above


Question:
Bins created in function are similar to:

1.Case Statement of Expression Function

2. Cast Statement of Conversion Function

3.Count Statement of Aggregate Function

4.RCount of Running Aggregate Function


Question:
Can DAC send an email just in case of any failures?

1.Yes

2.no

3.all of the above

4.None of the mentioned


Question:
Can we generate alpha-numeric value in sequence generator?

1. yes

2.no

3.all of the above

4.None of the mentioned


Question:
Can we run multiple execution plan at the same time in DAC?

1.Yes.

2.no

3.all of the above

4.None of the mentioned


Question:
Dimension tables are denormalized in nature ? True or False.

1.true

2.False

3.all of the above

4.None of the mentioned


Question:
For moving your shared dashboard and reports from dev to QA or Production you should:

1.paste dev catalog to qa / prod environment

2. paste only updated atr files to qa/prod

3.merge catalog changes through catalog manager

4.paste files and associated atr files to qa/prod


Question:
How can we load time dimension?

1.through Sql transformation

2.through Dimensional Loader (wrong)

3.Through Lookup

4.Through Store Procedure


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

1.Restart Java Host Services (Weblogic / oc4j)

2.Reload EPT

3.Reload Server Metadata

4.Refresh Display


Question:
If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value, can joiner will match that null value?

1. yes

2.no

3.all of the above

4.None of the mentioned


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

1.Use Filter option

2.Use Function Option

3.Use Column Format Option

4.Use Sorting Option


Question:
In ODI, references can be represented by

1.Simple equalities between columns in tables

2.Complex relationships between columns in tables

3.Expressions that must evaluate to true or false

4.All of the above


Question:
Repository can be uploaded/ updated from?

1.Capacity Management Tab of Fusion MiddleWare

2.Diagnostics Tab of Fusion MiddleWare

3.Overview Tab of Fusion MiddleWare

4.Deployment Tab of Fusion MiddleWare


Question:
The data is stored, retrieved and updated in........

1.OLAP

2.OLTP

3.SMTP

4.FTP


Question:
We can set Bridge table from

1.Properties of Physical Tables

2.Properties of Logical Table

3.Properties of LTS

4.Properties of Presentation Table


Question:
What are the components of DAC

1. DAC Server

2.DAC Client

3.W ebLogic Server

4.Informatica Server


Question:
What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?

1.Add one dummy port in two sources.

2.Use Joiner transformation to join the sources using dummy port

3.Use Union

4.In expression trans assign '1' to each port


Question:
What are the types of groups in Router transformation?

1.User defined group

2.Multiple Group

3.Default Group

4.Single Group


Question:
What cannot be done in presentation layer of Repository?

1.Nesting of folders

2.Set implicit fact column

3.Permission grant to groups/users for security

4. Performing calculations of measures


Question:
What do you use to Model a schema where the dimension table and the fact table have a many to many relationship ?

1.Complex Join

2.Aggregate Table

3.Helper Table

4.Bridge Table


Question:
What is a mapplet?

1.Combination of reusable transformation.

2.Combination of reusable mapping

3.Set of transformations and it allows us to reuse

4.None of these


Question:
What is default join of joiner?

1. Full Outer

2. Detail Outer

3.Normal

4.Master Outer


Question:
What is meaning of tracing level?

1.Data store in cache (wrong)

2.Data store in database

3.Data store in log file

4. Data store in buffer


Question:
What is the default join of Source Qualifier?

1.Left Outer join

2.Equi Join

3.Inner-equi join

4.Outer join


Question:
What is the default source option for update strategy?

1.Update or Delete

2.Update or Insert

3. Insert or Update

4. Date Driven


Question:
What is the name of the object that is used to initialize dynamic repository variable and system session variables for OBIEE Sessions ?

1.Tokens

2. Variables

3.Initialization Blocks

4. Meta Tags


Question:
What kind of DAC Repository Objects Held in Source System Containers?

1.Indexes

2.Tasks

3.Schemas

4.Workflows


Question:
What will happen if informatica server doesn't find session parameter and variable?

1.Work flow will fail

2.Automatically it will created

3.Give a message to user to put it

4.None of these


Question:
When you open a sales.rpd file in the BI Server repository directory, it displays a message “The
repository sales.rpd can only be opened as Read-Only. Do you want to open it ?”. What is the
correct statement ?

1.Oracle BI Presentation services is running

2.Sales.rpd file can be opened only in the Online mode

3. Oracle BI Server is running and Sales.rpd is the default repository

4.none of the above


Question:
Which are the load types in Informatica session?

1.Bulk

2.Terse

3.Normal

4. All of these


Question:
Which dimension is collection of random transactional codes, flags and/or text attributes?

1.degenerated

2. scd

3. junk

4. confirmed


Question:
Which is both connected and unconnected?

1.External Store Procedure

2.Store Procedure

3.Lookup

4.Advanced External Procedure Transformation


Question:
Which is not valid type of set operation for combine with similar request?

1.Union

2.Intersect

3.Minus

4.SubSet


Question:
Which layer within the Oracle BI Repository provides customized, role based views to users who build analyses and other client applications ?

1.Physical Layer

2.ETL Layer

3. Business Model and Mapping Layer

4.Presentation Layer


Question:
Which load type we should use in case of less amount of data and recover session?

1.verbose

2. normal

3.bulk

4.All of these


Question:
Which of the following is not a kind of data warehouse application?

1.Information processing

2.Analytical processing

3.Data mining

4.Transaction processing


Question:
Which of them is/are not Time Series Function?

1.Ago()

2. Todate()

3.Period()

4.PeriodRolling()


Question:
Which of these is not Hierarchy type?

1.Skipped Hierarchy

2. Composite Hierarchy

3.Parent Child Hierarchy

4.Ragged Hierarchy


Question:
Which one contains input and output transformations? 

1. maplet

2.reusable transformation

3. reusable mapping

4.None of the mentioned


Question:
Which one is not a designer tool creating transformations?

1.Transformation developer

2.Mapping designer

3. Mapplet designer.

4.target designer


Question:
Which one is not a target Option for file on the Servers?

1.FTP

2.Loader

3.MQ

4.ERP


Question:
Which one is not an option in update strategy?

1. dd_reject

2.4

3.2

4.dd_delete


Question:
Which one support heterogeneous join?

1.source qualifier

2.joiner

3. look up

4.None of the mentioned


Question:
Which output file is not created during session running?

1.Session log

2.workflow log

3.Error log

4.cache files


Question:
Which transformation acts like CASE.. WHEN in Sql?

1.filter

2.router

3.aggregator

4.look up


Question:
You can apply restriction/ filtration to data in metadata repository in:

1.Physical Layer Alias Table

2.Logical Table

3. Logical Table Source

4.Presentation Table


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

1.Manage Sessions

2.Manage Interactive Dashboard

3.Manage Privilege

4.Manage Presentation catalog group or users


Question:
You can start all BI services from fusion middleware from:

1.Capacity Management Tab of Fusion MiddleWare

2. Diagnostics Tab of Fusion MiddleWare

3.Overview Tab of Fusion MiddleWare

4.Deployment Tab of Fusion MiddleWare


More MCQS

  1. OBIEE 12C Mcq Question Set 1
  2. OBIEE 12C Mcq Question Set 2
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!