Oracle Warehouse Builder | OWB Quiz

Oracle Warehouse Builder [ OWB ] Quiz

 



Oracle Warehouse Builder Quiz contain set of 250 MCQ questions for OWB MCQ which will help you to clear beginner level quiz.



1) Control Center Service enables you to

  1. register locations and process flows.
  2. register locations and deploy from the Control Center Manager.
  3. ans) register locations and deploy from the Control Center Manager, and the ability to execute ETL mappings and process flows.
  4. None

Answer : C

 
 
2) OWB Supports Split Repositories Implementation

  1. ans) True
  2. FALSE

Answer : A

 
 
3) OWB can be installed on below platforms

  1. Windows
  2. Unix
  3. ans) Both
  4. None

Answer : C

 
 
4) If you plan to use Warehouse Builder process flows,
you need to install Oracle Workflow to enable
deployment.

  1. ans) True
  2. FALSE

Answer : A

 
 
5) Before installing OWB Oracle Database should be installed

  1. ans) True
  2. FALSE

Answer : A

 
 
6) All Warehouse Builder users and the repository owner must first be defined as

  1. OWB users
  2. Repository Users
  3. ans) Oracle
  4. Database users
  5. None

Answer : C

 
 
7) OWB supports below Metadata Security Strategies

  1. Minimal Metadata Security Strategy (Default)
  2. Multi-user Security Strategy
  3. Full Metadata Security Strategy
  4. ans) All

Answer : D

 
 
8) To Register Database Users as Warehouse Builder User

  1. go to the Security node in Design Center,
  2. right-click Users and select New. Follow the prompts in the wizard.
  3. go to the Security node in the Control Center,
  4. right-click Users and select New. Follow the prompts in the wizard.
  5. ans) go to the Security node in the Global Explorer,
  6. right-click Users and select New. Follow the prompts in the wizard.
  7. None

Answer : C

 
 
9) Oracle database user can created from OWB.

  1. NO
  2. ans) If Repository user has system privilege CREATE USER
  3. YES
  4. None

Answer : B

 
 
10) To register user as target Schema

  1. While creating user set it as target.
  2. ans) While registering select User Schema as Target Option
  3. None
  4. All of these

Answer : B

 
 
11) Below are Object Privileges for User.

  1. FULL CONTROL
  2. EDIT
  3. CREATE_SNAPSHOT
  4. ans) A and B

Answer : D

 
 
12) CREATE_PROJECT is

  1. Object Privilege
  2. ans) System Privilege
  3. Both
  4. None

Answer : B

 
 
13) Warehouse Builder enables multiple users to access the same Warehouse Builder
repository

  1. ans) True
  2. FALSE

Answer : A

 
 
14) If the delete option is not available for location then reason could be

  1. Only Administrator can delete locations
  2. ans) that the location has
  3. been registered in a control center and is likely being utilized
  4. Both
  5. None

Answer : B

 
 
15) In order to avoid entering location password every time we should set

  1. ans) Persist Location Password in Metadata
  2. Register location.
  3. Both
  4. None

Answer : A

 
 
16) For Connectors to get created automatically

  1. User should have privilege to create database link
  2. User should have privilege to create Database Directory
  3. ans) Both
  4. None

Answer : C

 
 
17) Export Diagram menu option can be used to

  1. Saves the current diagram displayed on the canvas as a file in repository.
  2. Saves the current diagram displayed on the canvas on
  3. server as an SVG file or JPEG file
  4. ans) Saves the current diagram displayed on the canvas as a file on
  5. your machine either as an SVG file or JPEG file
  6. None

Answer : C

 
 
18) We can create below partitions in OWB

  1. Hash By Quantity Partitioning
  2. List Partitioning
  3. Composite Partitioning
  4. ans) All of these

Answer : D

 
 
19) In Table configuration Logging mode can be set to

  1. Logging
  2. No Logging
  3. ans) Either Logging or No Logging
  4. None

Answer : C

 
 
20) Materialized Views can be configured in OWB

  1. ans) True
  2. FALSE

Answer : A

 
 
21) Dimensions can edited from OWB using

  1. ans) Data Object Editor
  2. Create Dimension Wizard
  3. Both
  4. None

Answer : A

 
 
22) OWB supports

  1. Only Type1 SCD
  2. Type1 SCD and Type2 SCD
  3. ans) Type1 SCD and Type2 SCD and Type3 SCD
  4. None

Answer : C

 
 
23) OWB supports Cube creation

  1. ans) True
  2. FALSE

Answer : A

 
 
24) Cubes that use a MOLAP implementation are stored in

  1. Repository
  2. Tables
  3. ans) analytic workspaces
  4. None

Answer : C

 
 
25) Warehouse Builder provides the Create Time Dimension wizard that enables you to
create a fully functional time dimension quickly.

  1. ans) True
  2. FALSE

Answer : A

 
 
26) Business Definitions are used for

  1. data analysis of data
  2. stored in Warehouse Builder
  3. deploying business objects to
  4. Oracle BI Discoverer
  5. ans) Both
  6. None

Answer : C

 
 
27) Oracle Designer objects can be used as source in
Warehouse Builder

  1. ans) True
  2. FALSE

Answer : A

 
 
28) MIMB stands for

  1. Meta Integration Model Box
  2. Meta Implementation Model Bridge
  3. ans) Meta Integration Model Bridge
  4. None

Answer : C

 
 
29) Warehouse Builder enables you to interpret and extract metadata from below custom and
packaged applications .

  1. E-Business Suite
  2. PeopleSoft
  3. SAP
  4. ans) All of these

Answer : D

 
 
30) OWB generates ABAP scripts to

  1. Extracts and loads data from E-Business Suite systems
  2. Extracts and loads data from PeopleSoft systems
  3. ans) Extracts and loads data from SAP systems
  4. None

Answer : C

 
 
31) process that enables you to analyze the content and structure of
your data to determine inconsistencies, anomalies, and redundancies in the data

  1. Data Validation
  2. ans) Data profiling
  3. Data Verification
  4. None

Answer : B

 
 
32) Below are Data Quality Operators

  1. Match-Merge Operator
  2. Name and Address Operator
  3. ans) Both
  4. None

Answer : C

 
 
33) Data Auditor Activity in Process flow is used to

  1. Validate process flow.
  2. ans) Adds to the process flow an existing data auditor monitor used in data
  3. Both
  4. None

Answer : B

 
 
34) Table Function Operator is used to

  1. manipulate a one input row at a time.
  2. ans) manipulate a set of input rows and return
  3. another set of rows of the same or different cardinality.
  4. manipulate a set of input rows and return
  5. another set of rows .
  6. None

Answer : B

 
 
35) Audit Reports can be viewed from

  1. Control Center Manager
  2. Repository Browser
  3. ans) Both
  4. None

Answer : C

 
 
36) Following type of Reports can be viewed from repository Browser

  1. Summary Reports
  2. Implementation Reports
  3. Lineage and Impact Analysis Reports and Diagrams
  4. ans) All of these

Answer : D

 
 
37) OMB Plus provides the following commands to export metadata

  1. OMBEXP
  2. ans) OMBEXPORT
  3. OMBEXPT
  4. None

Answer : B

 
 
38) Design solutions that
simplify routine tasks and implement best practices are called

  1. Profiles
  2. Advanced
  3. ans) Experts
  4. None

Answer : C

 
 
39) CLUSTER is a reserved Keyword in OWB

  1. ans) True
  2. FALSE

Answer : A

 
 
40) ROUND is a

  1. ans) Predefined Transformation
  2. Custom Transformation
  3. Both
  4. None

Answer : A

 
 
41) ALL_RT_AUDIT_LOCATIONS is

  1. API to create Locations
  2. ans) Locations Deployment Auditing View
  3. Locations Execution Auditing View
  4. None

Answer : B

 
 
42) ALL_IV_ALL_OBJECTS is a PUBLIC VIEW

  1. ans) True
  2. FALSE

Answer : A

 
 
43) deactivate_deployment script

  1. Deactivates a scheduled job
  2. ans) Deactivates a deployment job
  3. Deactivates an execution job
  4. None

Answer : B

 
 
44) service_doctor script

  1. Displays diagnostics about design center
  2. Displays diagnostics about the workflow manager.
  3. ans) Displays diagnostics about the Control Center repository and its
  4. service
  5. None

Answer : C

 
 
45) We can Schedule from SQL*PLUS

  1. OWB Mappings
  2. Process Flows
  3. ans) Both
  4. None

Answer : C

 
 
46) If a location cannot be unregistered using the Control Center Manager or an OMB*Plus
script then

  1. ans) Run the unregister_location script
  2. Delete Location
  3. Install Runtime Repository again
  4. None

Answer : A

 
 
47) OMB Plus, is an extension of

  1. Perl programming language
  2. ans) Tcl programming language
  3. Java programming language
  4. None

Answer : B

 
 
48) commands that comprise the OMB
Scripting Language are

  1. Metadata Manipulation Language (MML) Commands
  2. Shell Commands
  3. Administrative Commands
  4. ans) All of these

Answer : D

 
 
49) OMBCREATE command creates

  1. Modifies a first class object
  2. Retrieves information from a first class object
  3. ans) Creates a first class object
  4. None

Answer : C

 
 
50) OMBRETRIEVE is used to

  1. ans) Retrieve metadata of a component
  2. Retrieve location details
  3. Retrieve configuration details
  4. None

Answer : A

 
 
51) WB_IS_SPACE is

  1. ans) PreDefined Transformation
  2. Custom Transformation
  3. View
  4. None

Answer : A

 
 
52) We cannot import PL/SQL functions, procedures, and packages into a
Warehouse Builder project

  1. TRUE
  2. ans) False

Answer : B

 
 
53) OWB supports EXISTSNODE XML transformation

  1. ans) True
  2. FALSE

Answer : A

 
 
54) Oracle Warehouse Builder is Embedded in Oracle Database 11g and gets installed with database

  1. ans) True
  2. FALSE

Answer : A

 
 
55) Starting OWB 11g release SYSDBA Privileges No Longer Required for Installation

  1. ans) True
  2. FALSE

Answer : A

 
 
56) For OWB 11g release Oracle Workflow has to be installed separately

  1. TRUE
  2. ans) False

Answer : B

 
 
57) Workspaces are present in

  1. OWB 9i
  2. OWB 10gR2
  3. ans) OWB 11g
  4. None

Answer : C

 
 
58) OWB cannot be installed on RAC environment

  1. TRUE
  2. FALSE
  3. ans)

Answer : C

 
 
59) Below Strategies can be used for Managing Multiple Environments

  1. Multiple Environments Based on a Single Design Environment
  2. Multiple Environments Based on Multiple Design Environments
  3. ans) Both
  4. None

Answer : C

 
 
60) OWB 11g supports below Targets

  1. Oracle DB 8.1, 10.1, 10.2, 11.1
  2. Oracle DB 9.0, 10.1, 10.2, 11.1
  3. ans) Oracle DB 9.2, 10.1, 10.2, 11.1
  4. None

Answer : C

 
 
61) In OWB 11g Repository Browser Listener is started from command prompt

  1. ans) True
  2. FALSE

Answer : A

 
 
62) OWB 11g provides connector to Siebel

  1. ans) True
  2. FALSE

Answer : A

 
 
63) Below operator is used to Iterate through the values in the table type

  1. Table Operator
  2. Data Generator Operator
  3. ans) Varray Operator
  4. None

Answer : C

 
 
64) Below Display Set Includes only those attributes that are not connected to other attributes

  1. ALL
  2. MAPPED
  3. ans) UNMAPED
  4. None

Answer : C

 
 
65) Constant Operator is used to

  1. ans) Produce a single output group that can contain one or more constant attributes
  2. Produce a single output group that can contain one constant attributes
  3. Both
  4. None

Answer : A

 
 
66) When Warehouse Builder creates and maintains a temporary
table that stages the source data before initiating the partition exchange process, then it is termed as

  1. Direct PEL
  2. ans) Indirect PEL
  3. PEL
  4. None

Answer : B

 
 
67) Subprocess activity is used to

  1. ans) Embed an existing process flow within the process flow
  2. Call transformation in the process flow
  3. Both
  4. None

Answer : A

 
 
68) Repository Assistant is used to

  1. Create Repository
  2. Design center
  3. ans) define an Oracle Database as a Warehouse Builder
  4. repository
  5. None

Answer : C

 
 
69) Each repository

  1. must be associated with more than one repository owner
  2. ans) must be associated with at least one repository owner
  3. must be associated with one repository owner
  4. None

Answer : B

 
 
70) When we delete repository user from OWB

  1. ans) User gets deleted from Database
  2. User is deleted from OWB and database.
  3. Both
  4. None

Answer : A

 
 
71) Default role in OWB for users is

  1. All role
  2. ans) Everyone Role
  3. Administrator Role
  4. None

Answer : B

 
 
72) For taking backup in OWB we can use below methods

  1. Create Snapshots
  2. Take MDL backup
  3. ans) Both
  4. None

Answer : C

 
 
73) Warehouse Builder Repository Assistant logs are stored in below location

  1. ans) OWB_ORACLE_HOME\owb\UnifiedRepos\log_<timestamp>.log
  2. OWB_ORACLE_HOME\owb\log\Repository_Name\log.xx
  3. OWB_ORACLE_HOME\owb\log\Repository\log.xx
  4. None

Answer : A

 
 
74) To detect and resolve the impact of
the changes made to the object definitions or the metadata in the Warehouse Builder
repository we can use

  1. Metadata definitions
  2. ans) Metadata Dependency Manager
  3. Metadata configuration
  4. None

Answer : B

 
 
75) Core Functionality of OWB is?

  1. Design
  2. deployment
  3. management
  4. ans) All of these

Answer : D

 
 
76) Sources and targets are available in

  1. ans) Design Center
  2. Data Objects Editor
  3. Control Center
  4. None

Answer : A

 
 
77) OWB supports XML as target

  1. FALSE
  2. ans) True

Answer : B

 
 
78) Tables and Views are imported in ?

  1. Control Center
  2. Runtime Repository
  3. ans) Design Center
  4. None

Answer : C

 
 
79) Locations are used to store

  1. Database Objects
  2. ans) Connection Information
  3. Mappings
  4. process flows

Answer : B

 
 
80) We can create multiple projects in OWB

  1. ans) True
  2. FALSE

Answer : A

 
 
81) OWB supports below data model.

  1. Relational
  2. Dimensional
  3. ans) Both
  4. None

Answer : C

 
 
82) External Tables Represent

  1. Tables from databases other then Oracle
  2. ans) non-relational flat files in a relational format
  3. Both
  4. None

Answer : B

 
 
83) OWB supports CLOB data type

  1. ans) True
  2. FALSE

Answer : A

 
 
84) In OWB flat file can be used as

  1. Source
  2. Target
  3. ans) Both
  4. None

Answer : C

 
 
85) PIVOT is an operator in OWB

  1. ans) True
  2. FALSE

Answer : A

 
 
86) Pluggable Mapping Operator is used to

  1. As connection to other mappings
  2. Interface to external tables
  3. ans) Represents a reusable mapping
  4. All of these

Answer : C

 
 
87) We can Specify Target Load order in OWB

  1. FALSE
  2. ans) True

Answer : B

 
 
88) Process Flows can be used to

  1. Send Email notifications
  2. ans) Schedule mappings
  3. Both
  4. None

Answer : B

 
 
89) OWB can generate Code in

  1. PL/SQL
  2. SQL *Loader
  3. ABAP
  4. ans) All of these

Answer : D

 
 
90) Mappings can be developed in

  1. Design Center
  2. Control Center
  3. ans) Mapping Editor
  4. All of these

Answer : C

 
 
91) Mapping Editor can be used to Debug Mappings

  1. ans) True
  2. FALSE

Answer : A

 
 
92) Collections are used to

  1. Organize a large logical warehouse
  2. Validate and generate a group of objects
  3. ans) Both
  4. None

Answer : C

 
 
93) We cannot create Slowly Changing Dimensions in OWB

  1. ans) False
  2. TRUE

Answer : A

 
 
94) OMB Plus is

  1. Component of OWB
  2. ETL tool
  3. ans) scripting utility that enables to perform all operations available in the graphical user interfaces
  4. None

Answer : C

 
 
95) Module can correspond to

  1. Multiple locations
  2. ans) one location
  3. Both

Answer : B

 
 
96) We cannot delete

  1. The currently active or expanded project
  2. The only project in a repository
  3. ans) Both
  4. None

Answer : C

 
 
97) PEL stands for

  1. ans) Partition Exchange Loading
  2. Partition Extract Load
  3. Prepare Extract Load
  4. None

Answer : A

 
 
98) abort_exec_request script is used to

  1. Stop Service
  2. Kill OWB session
  3. ans) Stops an execution that is currently busy
  4. None

Answer : C

 
 
99) Sql*Plus can be used to schedule OWB jobs

  1. ans) True
  2. FALSE

Answer : A

 
 
100) Sorter Operator is

  1. Source and Target Operator
  2. ans) Data Flow Operator
  3. Pre/Post Processing Operator
  4. Pluggable Mapping Operator

Answer : B

 
 
101) Process Flows support

  1. For Loop
  2. While Loop
  3. ans) Both
  4. None

Answer : C

 
 
102) Mappings and Process Flows can be scheduled in

  1. ans) Design Center
  2. Control Center
  3. Data Objects Editor
  4. None

Answer : A

 
 
103) Repository Browser is used to

  1. Browse design metadata
  2. Audit Execution data
  3. Create Reports
  4. ans) All of these

Answer : D

 
 
104) Target Schema Contains

  1. Generated Code
  2. Mappings
  3. ans) Both
  4. None

Answer : C

 
 
105) OWB automatically creates a location for each user you register

  1. ans) True
  2. FALSE

Answer : A

 
 
106) Validation is the process of verifying metadata definitions and configuration
parameters

  1. FALSE
  2. ans) True

Answer : B

 
 
107) Below Data Object can be imported in OWB

  1. Dimensions
  2. Views
  3. ans) Both
  4. None

Answer : C

 
 
108) Canvas

  1. displays relational, objects
  2. ans) displays relational, dimensional, and
  3. business intelligence objects
  4. displays business intelligence objects
  5. None

Answer : B

 
 
109) The Data Viewer enables you to view the data stored in the data object

  1. FALSE
  2. ans) True

Answer : B

 
 
110) When you store dimension data in a relational form, you can implement the
dimension using

  1. Star Schema
  2. Snowflake Schema
  3. ans) Both
  4. None

Answer : C

 
 
111) In Below Operating Mode Warehouse Builder generates a single SQL statement that processes
all data and performs all operations

  1. Row based
  2. ans) Set based
  3. Set based fail over to row based
  4. None

Answer : B

 
 
112) Manual Commit is supported in OWB Mappings

  1. FALSE
  2. ans) True

Answer : B

 
 
113) Transform Activity is used in Process Flow to

  1. Transform Data
  2. ans) Add an existing transformation to the process flow
  3. Create new transformation
  4. None

Answer : B

 
 
114) Subprocess is used to Embed an existing process flow within the process flow

  1. ans) True
  2. FALSE

Answer : A

 
 
115) Benefits of using Transportable Modules are

  1. High Performance Data Extraction
  2. Distribute and Archive Datamarts
  3. Archive Sources
  4. ans) All of these

Answer : D

 
 
116) In Below Operating Mode Warehouse Builder generates a cursor select statement and attempts to include as many operations as possible in the cursor

  1. Row based
  2. Set based
  3. ans) Row based (Target Only)
  4. None

Answer : C

 
 
117) IN OWB Mappings we can have one Source and Multiple Targets

  1. ans) True
  2. FALSE

Answer : A

 
 
118) IN OWB Transformation Libraries can be accessed using

  1. Expression Builder
  2. Add Transformation Operator dialog
  3. Create Transformation Wizard
  4. ans) All of these

Answer : D

 
 
119) Constraints can be created using

  1. Design Center
  2. ans) Data Object Editor
  3. Control Center
  4. All of these

Answer : B

 
 
120) Below are runtime Parameters for Mappings

  1. Bulk Size
  2. Commit Frequency
  3. ans) Both
  4. None

Answer : C

 
 
121) Metadata Loader is used to

  1. populate a new repository as well as
  2. restore a backup of existing repository metadata
  3. populate a new repository as well as
  4. update, or restore a backup of existing repository metadata
  5. ans) populate a new repository as well as
  6. transfer, update, or restore a backup of existing repository metadata
  7. None

Answer : C

 
 
122) Design center is used for

  1. Designing
  2. Managing
  3. Scheduling
  4. ans) ALL

Answer : D

 
 
123) Repository browser can be used

  1. ans) To report on the metadata in the repository (
  2. To create the repository
  3. To design repository
  4. None of the above

Answer : A

 
 
124) Multiple target schema can be associated with single OWB repository

  1. ans) True
  2. FALSE

Answer : A

 
 
125) OWB repository can be hosted on Non oracle databases

  1. TRUE
  2. ans) False

Answer : B

 
 
126) Where can you register your locations

  1. Repository browse
  2. ans) Control center Service
  3. Target schema
  4. OWB repository

Answer : B

 
 
127) OWB mappings will be deployed in

  1. OWB repository
  2. Target schema
  3. Workspaces
  4. ans) Control center service

Answer : D

 
 
128) Set Operator in OWB supports

  1. Intersect
  2. Minus
  3. Union
  4. ans) All of the above

Answer : D

 
 
129) The default ‘Remaining_Rows’ group in Splitter can be removed

  1. TRUE
  2. ans) False

Answer : B

 
 
130) When you deploy a mapping you must generate

  1. ans) Runtime repository connection
  2. Designtime repository connection
  3. Both
  4. None of the above

Answer : A

 
 
131) Loading types of Oracle Target operator

  1. Delete
  2. Check/Insert
  3. Tuncate/Insert
  4. ans) All of the above

Answer : D

 
 
132) Which of the below loading type will append additional data to the target

  1. Check/Insert
  2. ans) Insert/Update
  3. All
  4. None

Answer : B

 
 
133) Match by constraint condition can be used in the Target operator to perform the below

  1. ans) Insert & Delete
  2. Insert/Update
  3. Both
  4. None

Answer : A

 
 
134) Which of the following mapping source operators are not supported when running mappings in debug mode.

  1. Advanced Ques
  2. Flat file
  3. Source table from an ABAP application
  4. ans) All

Answer : D

 
 
135) Data Generator operator can be used to generate

  1. RECNUM
  2. SYSDATE
  3. SEQUENCE
  4. ans) All of the above

Answer : D

 
 
136) Deduplicator can be used to Sort the records

  1. TRUE
  2. ans) False

Answer : B

 
 
137) Join condition expression cannot contain aggregation functions

  1. ans) True
  2. FALSE

Answer : A

 
 
138) It is possible to specify a full outer join in Joiner operator

  1. ans) True
  2. FALSE

Answer : A

 
 
139) You can pass external information to a mapping using parameter

  1. ans) True
  2. FALSE

Answer : A

 
 
140) Which of the below statement is true

  1. It is possible to send external values to a mapping
  2. It is possible to send out values from a mapping
  3. ans) A&B
  4. None

Answer : C

 
 
141) It is possible to call a procedure from expression operator

  1. ans) True
  2. FALSE

Answer : A

 
 
142) Possible Code generation options are

  1. Correlated Commit
  2. Optimized Code
  3. Bulk Processing Code
  4. ans) All of the above

Answer : D

 
 
143) Possible export options are

  1. Single mapping
  2. Multiple mappings
  3. Project
  4. ans) All of the above

Answer : D

 
 
144) Which is the scripting language used for OWB

  1. ans) OMB
  2. MDX
  3. MDL
  4. None of the above

Answer : A

 
 
145) It is possible to set processing order when you have multiple flows in the mapping

  1. TRUE
  2. ans) False

Answer : B

 
 
146) File extension of Mapping export is

  1. .OWB
  2. ans) .MDL
  3. .SQL
  4. .MDX

Answer : B

 
 
147) Oracle Warehouse Builder is used as a tool to implement which one of the below solution?

  1. Integrating the Data
  2. Extraction, Transformation & Loading
  3. Data Quality & Consolidation
  4. ans) All of Above

Answer : D

 
 
148) Oracle Warehouse Builder uses which functionality to Access numerous third-party databases, applications, files, and
data stores?

  1. Application Links
  2. Database Links
  3. Heterogeneous Services
  4. ans) Server Links

Answer : D

 
 
149) Which one is not a Oracle Warehouse Builder Component?

  1. Control Center Manager
  2. Warehouse Builder Repository
  3. Work Spaces
  4. ans) Session Manager

Answer : D

 
 
150) Which one is not a Warehouse Builder Client Side Component?

  1. Repository Browser
  2. Design Center
  3. Control Center Manager
  4. ans) Work Spaces

Answer : D

 
 
151) Physical properties of the object can be set

  1. While Deploying the Data Objects
  2. While Validating the Data Objects
  3. ans) Set by Configuring the Data Objects
  4. None of the Above

Answer : C

 
 
152) Oracle Warehouse Builder Generates the code of

  1. SQL
  2. ans) PL/SQL
  3. JAVA
  4. C++

Answer : B

 
 
153) Mapping Editor enables you to define

  1. Work Flow Visually
  2. ans) Data Flow Visually
  3. Session Flow Visually
  4. All of Above

Answer : B

 
 
154) OWB Logging Preferences enables you to set

  1. OWB Login Parameters
  2. Database Login Parameters
  3. ans) Log File Options
  4. All of Above

Answer : C

 
 
155) Which one is not a type of Location in OWB

  1. Databases
  2. Applications
  3. Files
  4. ans) Schema

Answer : D

 
 
156) Where to Create a Location in OWB ?

  1. Open Location Explorer, Locations Node
  2. Open Project Explorer, Locations Node
  3. ans) Open Connection Explorer, Locations Node
  4. None of Above

Answer : C

 
 
157) Steps to Import Metadata into OWB ( Assume that Project, Location, Module is created and configured properly)

  1. Right click on Location and Select Import, follow instructions in the Wizard
  2. ans) Right click on Module and Select Import, follow instructions in the Wizard
  3. Right click on Project and Select Import, follow instructions in the Wizard
  4. All of Above

Answer : B

 
 
158) Error Table Name option for a Table configuration indicates the name of the

  1. ans) Table name stores the rows that were not loaded into the table during a load operation.
  2. Table name stores the rows that were not loaded into all of the tables in the mapping during a load operation.
  3. Table name stores the rows that were not loaded into the tables in all of the mappings during a load operation.
  4. All of Above

Answer : A

 
 
159) Which one from below list is not an OWB OPERATOR?

  1. ans) Router
  2. Sorter
  3. Key lookup
  4. Match Merge

Answer : A

 
 
160) Key Lookup operator can perform lookup of data on

  1. ans) Tables , Views, Dimensions, Cubes
  2. Tables , Views, Dimensions
  3. Tables , Views
  4. Tables

Answer : A

 
 
161) Splitter operator does

  1. Splits a single column set into several output column sets using a Boolean split condition
  2. ans) Splits a single input row set into several output row sets using a Boolean split condition
  3. Splits a several input row set into several output row sets using a Boolean split condition
  4. All of Above

Answer : B

 
 
162) To call the PL/SQL Function or Stored Procedure which operators should be used

  1. Transformation or Table Function
  2. Expression or Table Function
  3. Transformation or Expression or Table Function
  4. ans) Transformation or Expression

Answer : D

 
 
163) Match and Merge is

  1. ans) OWB Data quality operator that identifies matching records and merges them into a single record
  2. OWB functionality that identifies multiple data objects and merges them into a single data object
  3. OWB component that identifies multiple work flow objects and merges them into a single work flow object
  4. None of above

Answer : A

 
 
164) OMB Plus is a

  1. ans) Scripting Interface for OWB
  2. Connection Interface for OWB
  3. Connection Interface for OWB
  4. None of Above

Answer : A

 
 
165) Pre/Post Processing Operators are

  1. ans) perform processing before or after executing a mapping
  2. perform processing before or after loading the data into a Target table
  3. perform processing before or after selecting the data from a Source table
  4. All of Above

Answer : A

 
 
166) The pivot operator enables or used to

  1. ans) transform a single row of attributes into multiple rows.
  2. transform a multiple rows of attributes into single row.
  3. transform a multiple table rows of data into single table row.
  4. None of above

Answer : A

 
 
167) Re-Usability can be implemented using which OWB Operator

  1. ans) Pluggable Mapping Operators
  2. Mapplets
  3. Table Function Operator
  4. All of Above

Answer : A

 
 
168) Target Load Order is used to specify

  1. Mappings load ordering within a work flow
  2. ans) Tables load ordering within a mapping
  3. Tables load ordering across all mappings
  4. None of above

Answer : B

 
 
169) Operator Wizards in the mapping editor will

  1. ans) Guide to define or usage of the operator in a mapping
  2. Create a new custom operator to use in the mapping
  3. Create a new re-usable custom operator to use in all projects
  4. None of Above

Answer : A

 
 
170) Which of the OWB component used for Profiling and analyzing quality of the data

  1. ans) Data Profile Editor
  2. Data Quality Editor
  3. Data Analysis Editor
  4. None of Above

Answer : A

 
 
171) Which one from below list is not a deployment action in OWB Deployment Process

  1. Create
  2. Upgrade
  3. Drop
  4. ans) Merge

Answer : D

 
 
172) OWB Naming Preferences enables to set

  1. ans) objects in business or physical name mode
  2. Objects Naming Standards
  3. Session and Project Naming Standards
  4. All of Above

Answer : A

 
 
173) Name and Address is

  1. A Module in OWB should be used for Identifies and corrects errors and inconsistencies in name and address source data.
  2. A Type of Connection in OWB should be used for Identifies and corrects errors and inconsistencies in name and address source data.
  3. ans) A Operator in OWB should be used for Identifies and corrects errors and inconsistencies in name and address source data.
  4. None of Above

Answer : C

 
 
174) Synchronizing From a Workspace Object to an Operator is used for

  1. ans) When you make changes to an workspace object in a module, you may want to propagate those changes to its corresponding mapping operator
  2. When you make changes to an operator in a mapping, you may want to propagate those changes to its corresponding workspace definition
  3. When you make changes to Table operator in a mapping, you may want to propagate those changes in the corresponding view object.
  4. All of Above.

Answer : A

 
 
175) Synchronizing from an Operator to a Workspace Object is used for

  1. ans) When you make changes to an operator in a mapping, you may want to propagate those changes to its corresponding workspace definition
  2. When you make changes to an workspace object in a module, you may want to propagate those changes to its corresponding mapping operator
  3. When you make changes to Table operator in a mapping, you may want to propagate those changes in the corresponding view object.
  4. All of Above.

Answer : A

 
 
176) Which one is not a Matching Strategy while synchronizing ?

  1. Match by Object Identifier
  2. Match by Bound Name
  3. Match by Position
  4. ans) Match by Sequence

Answer : D

 
 
177) A process flow describes dependencies between

  1. ans) Warehouse Builder mappings and external activities such as email, FTP, and operating system commands.
  2. Oracle Warehouse Builder mappings only
  3. Oracle Warehouse Builder Sessions only
  4. None of Above

Answer : A

 
 
178) Define the use of transitions in Work flow

  1. ans) to indicate the sequence and conditions in which activities occur in the process flow
  2. to indicate the sequence and conditions in which operators should execute in the process flow
  3. to indicate the sequence and conditions in which mappings should execute in the process flow
  4. all of above

Answer : A

 
 
179) OWB Locations enables you to

  1. ans) store the connection information to the various files, databases, and applications
  2. store the metadata from the various files, databases, and applications
  3. store the datafrom the various files, databases, and applications
  4. None of Above

Answer : A

 
 
180) You can embed commit logic ingo PL/SQL mapping using

  1. Expression Operator
  2. ans) PRE or POST Mapping Operator
  3. Pivot Operator
  4. Sorter Operator

Answer : B

 
 
181) One of the following is Invalid Operating Mode in PL/SQL mapping

  1. Set Based
  2. Row based
  3. Set based fail over to row based
  4. ans) Bulk Loading

Answer : D

 
 
182) Connector between a Schema nd Operating System is implemented via

  1. Oracle DB Link
  2. ans) Database Directory
  3. Symbolic Link
  4. None of the above

Answer : B

 
 
183) One of the following is not a valid transformation

  1. ans) Trigger
  2. Function
  3. Procedure
  4. Package

Answer : A

 
 
184) “Target Load Order” proprety in mapping configuration applies to

  1. Mapping with Single target
  2. ABAP Mapping
  3. Mapping with SQL * Loader
  4. ans) None of the above

Answer : D

 
 
185) One of the following is InValid OWB Operator

  1. Key Lookup Operator
  2. Materialized View Operator
  3. Cube Operator
  4. ans) Object Type Operator

Answer : D

 
 
186) When Synchronizing an operator in a mapping with a repository Object using “Object Identfier” we can match :

  1. Objects with different Type
  2. ans) Objects of Same Type
  3. Objects with Same Name
  4. None of the above

Answer : B

 
 
187) The following Runtime cannot be overridden when a mapping is executed

  1. Bulk Size
  2. Commit Frequency
  3. ans) Target Load Order
  4. Maximum Number of Errros

Answer : C

 
 
188) Find the Invalid Loading Type Property for Oracle Target Operator

  1. ans) Conventional Path Load
  2. Update/Insert
  3. None
  4. Truncate/Insert

Answer : A

 
 
189) Deleting a Location which is registered to use in control center

  1. Right click the Location and select Delete
  2. Right Click the Location in Design Center and click Unregister and then perform Delete
  3. ans) Right Click the Location in Control Center and click Unregister and then perform Delete in Design Center
  4. Not Possible to Delete a Location

Answer : C

 
 
190) Based on the ETL logic that you define in a mapping, Warehouse Builder generates the
code required to implement your design. Warehouse Builder can generate code for the
following language

  1. ans) ABAP
  2. PERL
  3. Java
  4. JavaScript

Answer : A

 
 
191) The following is not a source or Target Operator

  1. Cube Opeartor
  2. Varray Iterator
  3. Data Generator
  4. ans) Filter Operator

Answer : D

 
 
192) Pluggable Mapping Operator is

  1. ans) Represents a reusable mapping.
  2. A combination of input attributes that flow into the
  3. pluggable mapping.
  4. A combination of output attributes that flow out of the
  5. pluggable mapping.
  6. None of the above

Answer : A

 
 
193) When a mapping is deployed, the PLSQL code is

  1. ans) Deployed in Target Schema
  2. Deployed in Source Schema
  3. Deployed into OWB Repository
  4. None of the above

Answer : A

 
 
194) Default property of “Commit Control” Property of a mapping

  1. Manual
  2. Automatic Correlated
  3. ans) Automatic
  4. None of the above

Answer : C

 
 
195) Setting “Optimized Code” to TRUE

  1. Generates Optimized code for single table insert
  2. ans) generates a Multi Table insert SQL statement
  3. Generates Separate Insert statements for multi target mapping
  4. None of the above

Answer : B

 
 
196) Flat file as source, OWB generates

  1. ans) SQL * Loader Control file to load the data
  2. Generates script to parse the File and Load the data
  3. Generates Java Code to process the flat file
  4. None of the above

Answer : A

 
 
197) Flat File as Target, for this mapping the “Language” has a Valid Value of

  1. SQL * Loader
  2. PL/SQL
  3. ABAP
  4. ans) All of the above

Answer : D

 
 
198) Flat File as Target, Code is generated for this mapping only when “Default Operating” value is

  1. Set Based
  2. Row based
  3. ans) Row based(target only)
  4. all of the above

Answer : C

 
 
199) In process flow, the activity property “Remote Location” is used for

  1. ans) FTP
  2. Target Database
  3. File
  4. all of the above

Answer : A

 
 
200) In process flow, the activity property “Working Location” is used for

  1. FTP
  2. FILE EXISTS
  3. External Process
  4. ans) all of the above

Answer : D

 
 
201) Which SCD’s are supported by OWB as part of Enterprise ETL mappings?

  1. Creating Slowly Changing Dimension Type 2
  2. Creating Slowly Changing Dimension Type 3
  3. ans) Creating Slowly Changing Dimension Type 2&3
  4. None of the above

Answer : C

 
 
202) Does OWB support XML files as Target

  1. ans) True
  2. FALSE

Answer : A

 
 
203) What are locations?

  1. Physical definations of storage areas
  2. Logical Storage schema location
  3. Physical storage area location
  4. ans) Logical definations of storage areas.

Answer : D

 
 
204) The runtime repository is the place where OWB keeps all the required information about deployment and execution of ETL procedures.

  1. FALSE
  2. ans) True

Answer : B

 
 
205) A design repository where ETL procedures and related objects are modeled on a logical level.

  1. ans) True
  2. FALSE

Answer : A

 
 
206) What does OWB Connector E-Business Suite provide access to

  1. Only Technical Metadata
  2. Only Business Metadata
  3. ans) Both Technical & Business Metadata
  4. None of the above

Answer : C

 
 
207) What are the two main execution modes and variants supported by execution engine?

  1. Set Based and Rule Based
  2. Rule Based and Run Based
  3. ans) Set based and Row based
  4. Rule based and Schedule based

Answer : C

 
 
208) Is Row based execution mode is better than Set based?

  1. FALSE
  2. ans) True

Answer : B

 
 
209) The information displayed through a Design center is actually stored in one of the following places.

  1. Target Database
  2. ans) OWB Workspace/Metadata Repository
  3. Source Database
  4. None

Answer : B

 
 
210) What are the possible source operators for OWB map.

  1. ans) Table
  2. Flat File
  3. Materialized views
  4. All

Answer : A

 
 
211) An OWB Map can be executed in the following Modes

  1. Set Based
  2. Row Based
  3. Set Based Failover to Row Based
  4. ans) All

Answer : D

 
 
212) Insert/Update Type used the following SQL operation

  1. First Insert then Update
  2. First Update then Insert
  3. ans) Merge
  4. None

Answer : C

 
 
213) You found a small mistake in a deployed map. In order to correct It what you should do.

  1. ans) Correct it in the mapping editor
  2. Correct it in the database PLSQL package
  3. Both
  4. None

Answer : A

 
 
214) A map which loads data from a file to a database table generates the following type of code

  1. ans) SQL Loader Script
  2. PLSQL Package
  3. SQL Code
  4. All

Answer : A

 
 
215) For a SQL Loaded Type of MAP which one should be used to generate sequential numbers.

  1. Mapping Sequence
  2. ans) Data Generator
  3. Procedure
  4. None

Answer : B

 
 
216) In a process flow, to run a unix script which operator you will use.

  1. Sub process
  2. ans) External Process
  3. Forking Process
  4. All

Answer : B

 
 
217) An object can be deployed through which editor

  1. Design Center
  2. Control Center
  3. ans) Both
  4. None

Answer : C

 
 
218) Which one of the following is true for a Collection.

  1. It creates a copy of an object in the named collection
  2. ans) it creates a shortcut of the objects in the named collection
  3. It creates new objects in the named collection
  4. All

Answer : B

 
 
219) A Set operator can perform the following functions

  1. Union
  2. Union All
  3. Minus
  4. ans) All

Answer : D

 
 
220) Which one is a data quality operator in OWB

  1. Post Mapping Process
  2. Pivot
  3. ans) Match and Merge
  4. All

Answer : C

 
 
221) Process Flow generates the following type of codes

  1. PLSQL Code
  2. ans) XML Code
  3. Perl Script
  4. Java Code

Answer : B

 
 
222) A Post Map can be triggered on which condition

  1. Success of a map
  2. Failure of a Map
  3. Warning of a Map
  4. ans) All

Answer : D

 
 
223) A Commit Frequency can be set in one of the following place in a Map

  1. Target Property
  2. ans) Mapping Configuration Run time Property
  3. Target Database
  4. All

Answer : B

 
 
224) Where do you created the definition of external tables

  1. ans) Design Center/OWB Client
  2. Target Database
  3. Source Database
  4. All

Answer : A

 
 
225) A connector implemented in database can be a

  1. A dblink
  2. A directory
  3. ans) both
  4. None

Answer : C

 
 
226) A Map can execute the following objects

  1. Package
  2. Procedure
  3. Function
  4. ans) All

Answer : D

 
 
227) Which of the following operations can not be done on the target table in a map.

  1. Delete/Insert
  2. Truncate/Insert
  3. ans) select
  4. Update

Answer : C

 
 
228) The same table can be used as both source and target

  1. Same table can not be used for both.
  2. ans) Yes, it can be used without any problem.
  3. It can be theoretically possible but generates erroneous results.
  4. None

Answer : B

 
 
229) You have modified the table definition in OWB. If you want to use new definition in a existing map what you will do.

  1. ans) Reconcile Inbound
  2. Reconcile Outbound
  3. Create a new Map
  4. None

Answer : A

 
 
230) In a map, while using the UPDATE option, how do you decide the columns which will be used for matching the rows in target table

  1. Based on Primary Key
  2. Based on unique key
  3. ans) Both
  4. None

Answer : C

 
 
231) SCD2 type of maps can be developed using OWB

  1. OWB does not support SCD2
  2. ans) SCD2 can be implemented using a combination of operators.
  3. SCD2 can only be implemented by writing PLSQL code not by operator
  4. None

Answer : B

 
 
232) An OWB map can be executed in which of the following way

  1. Using Process Flow
  2. Using Deployment Manager/Control Center
  3. Using PLSQL script
  4. ans) All

Answer : D

 
 
233) If a Map fails due to reaching maximum number of error set in the configuration, how do you find out those erroneous records.

  1. Querying in Target database
  2. ans) Querying in OWB Repository
  3. Write a special package to capture them.
  4. There is no way to find those records.

Answer : B

 
 
234) Oracle allows to view OWB repository and run time data in the following way.

  1. Self Made SQL
  2. Repository Browser based reports.
  3. ans) Both
  4. None

Answer : C

 
 
235) One important new feature in OWB 11g

  1. Match and Merger
  2. ans) Date Watch and Repair
  3. Name and Address
  4. Unpivot

Answer : B

 
 
236) What operator should be used for generate sequential number for a SQL Loader Script

  1. Sequence Generator
  2. ans) Data Generator
  3. Procedures
  4. None

Answer : B

 
 
237) Which one is a data quality operator

  1. Filter Operator
  2. Transformation Operator
  3. ans) Match and Merge
  4. None

Answer : C

 
 
238) While proposing OWB as an ETL tool to customer which one of the following is the most important point for consideration.

  1. Volume of incremental data is very high.
  2. ans) Target is an Oracle Database
  3. Source as SAP R/3
  4. All

Answer : B

 
 
239) Snapshot is taken for

  1. Debugging
  2. Security
  3. ans) Change Management
  4. None

Answer : C

 
 
240) Which one of the following is a performance tuning feature in OWB

  1. Filter Operator
  2. Using TRUNCATE/INSERT in Target table
  3. ans) Using database hint.
  4. SET Operator

Answer : C

 
 
241) if OWB maps fails on reaching max error where do you find erroneous records

  1. In target schema
  2. ans) In OWB Runtime Repository
  3. In Source Database
  4. All

Answer : B

 
 
242) How can you run/execute OWB maps

  1. Using DBMS_JOB/Schedule
  2. Using Procedures
  3. Using Processflow
  4. ans) ALL

Answer : D

 
 
243) In database how OWB Bulk Processing works.

  1. It uses only database cursor based operation
  2. It generates code which is similar like “insert into table2 (select * from table1”
  3. ans) It uses both cursor and array/table type variable.
  4. None

Answer : C

 
 
244) How do you set correlated commit in a Map

  1. ans) In Mapping configuration parameter
  2. In process flow parameters
  3. In target parameter
  4. ALL

Answer : A

 
 
245) In which of the following cases you would correct the code in the OWB deployed PLSQL package.

  1. To correct proper MERGE operation.
  2. To add a hint in target table
  3. To force a certain type of operation like ROW/SET based.
  4. ans) There would be no such cases when you need to correct in generated PLSQL Package.

Answer : D

 
 
246) How do perform tune a OWB Map

  1. Setting operation Mode ROW/SET based.
  2. Placing SQL and PLSQL operators wisely.
  3. Setting Analyze table option to ‘TRUE”
  4. ans) All

Answer : D

 
 
247) Where do you deploy SQLLoader Script

  1. In Target Schema
  2. In Source Schema
  3. ans) In file system
  4. in Processflow.

Answer : C

 
 
248) Which one is a maintenance task in an existing OWB environment

  1. Gradually reducing volume of source data
  2. Changing configuration parameters
  3. ans) purging runtime repository
  4. All

Answer : C

 
 
249) Which one of the following action will recover your OWB project from database crash.

  1. Recovering Target database from backup.
  2. ans) Recovering OWB repository schema from backup.
  3. Installing fresh OWB repository.
  4. All

Answer : B

 
 
250) Following process can be used for version control inside OWB.

  1. Snapshot
  2. Collection
  3. Export .mdl file
  4. ans) All

Answer : D

 
 
251) If a Map is executed using processflow where do you set the runtime parameters.

  1. In the configuration parameter of the map
  2. ans) In the processflow parameters for a Map
  3. In the database after deploying the map.
  4. None

Answer : B

 
 
252) How do you restore execution plan for a OWB Map.

  1. By redeploying the same map.
  2. ans) It can only be done in target database by restoring statistics.
  3. Restarting the database.
  4. None

Answer : B

 
 
253) While creating Runtime repository, do OWB create objects in the following schema.

  1. ans) Both in OWB Repository and target schema
  2. Only in OWB repository schema.
  3. Both Source and Target schema.
  4. In all schemas Source,Target and OWB repository.

Answer : A

 
 
254) Which one of the following may generate an outer Join.

  1. Unpivot Operator
  2. Join Operator with all inner Joins
  3. ans) Splitter Operator
  4. Keylook Up Operator

Answer : C

 
 
255) How does a CONSTANT operator gets implemented inside the package

  1. Constant values need to be passed from outside the map.
  2. No Code is generated for a Constant
  3. ans) Mainly as a select from Oracle Dual table.
  4. None

Answer : C

 
 
256) Which one of the following are allowed only once in a Map

  1. Pre-Mapping Operator
  2. Post-Mapping Operator
  3. Operator Mapping Input Parameter
  4. ans) All

Answer : D

 
 
257) If using a 3rd Party configuration tool which one of the following is a must.

  1. Ensuring Database Package generated by OWB is version controlled
  2. ans) Ensuring OWB Objects (Maps, Process Flows etc) are version controlled
  3. 3rd Party Change Management tool can not perform configuration management for OWB.
  4. None

Answer : B