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
- register locations and process flows.
- register locations and deploy from the Control Center Manager.
- ans) register locations and deploy from the Control Center Manager, and the ability to execute ETL mappings and process flows.
- None
2) OWB Supports Split Repositories Implementation
- ans) True
- FALSE
3) OWB can be installed on below platforms
- Windows
- Unix
- ans) Both
- None
4) If you plan to use Warehouse Builder process flows,
you need to install Oracle Workflow to enable
deployment.
- ans) True
- FALSE
5) Before installing OWB Oracle Database should be installed
- ans) True
- FALSE
6) All Warehouse Builder users and the repository owner must first be defined as
- OWB users
- Repository Users
- ans) Oracle
- Database users
- None
7) OWB supports below Metadata Security Strategies
- Minimal Metadata Security Strategy (Default)
- Multi-user Security Strategy
- Full Metadata Security Strategy
- ans) All
8) To Register Database Users as Warehouse Builder User
- go to the Security node in Design Center,
- right-click Users and select New. Follow the prompts in the wizard.
- go to the Security node in the Control Center,
- right-click Users and select New. Follow the prompts in the wizard.
- ans) go to the Security node in the Global Explorer,
- right-click Users and select New. Follow the prompts in the wizard.
- None
9) Oracle database user can created from OWB.
- NO
- ans) If Repository user has system privilege CREATE USER
- YES
- None
10) To register user as target Schema
- While creating user set it as target.
- ans) While registering select User Schema as Target Option
- None
- All of these
11) Below are Object Privileges for User.
- FULL CONTROL
- EDIT
- CREATE_SNAPSHOT
- ans) A and B
12) CREATE_PROJECT is
- Object Privilege
- ans) System Privilege
- Both
- None
13) Warehouse Builder enables multiple users to access the same Warehouse Builder
repository
- ans) True
- FALSE
14) If the delete option is not available for location then reason could be
- Only Administrator can delete locations
- ans) that the location has
- been registered in a control center and is likely being utilized
- Both
- None
15) In order to avoid entering location password every time we should set
- ans) Persist Location Password in Metadata
- Register location.
- Both
- None
16) For Connectors to get created automatically
- User should have privilege to create database link
- User should have privilege to create Database Directory
- ans) Both
- None
17) Export Diagram menu option can be used to
- Saves the current diagram displayed on the canvas as a file in repository.
- Saves the current diagram displayed on the canvas on
- server as an SVG file or JPEG file
- ans) Saves the current diagram displayed on the canvas as a file on
- your machine either as an SVG file or JPEG file
- None
18) We can create below partitions in OWB
- Hash By Quantity Partitioning
- List Partitioning
- Composite Partitioning
- ans) All of these
19) In Table configuration Logging mode can be set to
- Logging
- No Logging
- ans) Either Logging or No Logging
- None
20) Materialized Views can be configured in OWB
- ans) True
- FALSE
21) Dimensions can edited from OWB using
- ans) Data Object Editor
- Create Dimension Wizard
- Both
- None
22) OWB supports
- Only Type1 SCD
- Type1 SCD and Type2 SCD
- ans) Type1 SCD and Type2 SCD and Type3 SCD
- None
23) OWB supports Cube creation
- ans) True
- FALSE
24) Cubes that use a MOLAP implementation are stored in
- Repository
- Tables
- ans) analytic workspaces
- None
25) Warehouse Builder provides the Create Time Dimension wizard that enables you to
create a fully functional time dimension quickly.
- ans) True
- FALSE
26) Business Definitions are used for
- data analysis of data
- stored in Warehouse Builder
- deploying business objects to
- Oracle BI Discoverer
- ans) Both
- None
27) Oracle Designer objects can be used as source in
Warehouse Builder
- ans) True
- FALSE
28) MIMB stands for
- Meta Integration Model Box
- Meta Implementation Model Bridge
- ans) Meta Integration Model Bridge
- None
29) Warehouse Builder enables you to interpret and extract metadata from below custom and
packaged applications .
- E-Business Suite
- PeopleSoft
- SAP
- ans) All of these
30) OWB generates ABAP scripts to
- Extracts and loads data from E-Business Suite systems
- Extracts and loads data from PeopleSoft systems
- ans) Extracts and loads data from SAP systems
- None
31) process that enables you to analyze the content and structure of
your data to determine inconsistencies, anomalies, and redundancies in the data
- Data Validation
- ans) Data profiling
- Data Verification
- None
32) Below are Data Quality Operators
- Match-Merge Operator
- Name and Address Operator
- ans) Both
- None
33) Data Auditor Activity in Process flow is used to
- Validate process flow.
- ans) Adds to the process flow an existing data auditor monitor used in data
- Both
- None
34) Table Function Operator is used to
- manipulate a one input row at a time.
- ans) manipulate a set of input rows and return
- another set of rows of the same or different cardinality.
- manipulate a set of input rows and return
- another set of rows .
- None
35) Audit Reports can be viewed from
- Control Center Manager
- Repository Browser
- ans) Both
- None
36) Following type of Reports can be viewed from repository Browser
- Summary Reports
- Implementation Reports
- Lineage and Impact Analysis Reports and Diagrams
- ans) All of these
37) OMB Plus provides the following commands to export metadata
- OMBEXP
- ans) OMBEXPORT
- OMBEXPT
- None
38) Design solutions that
simplify routine tasks and implement best practices are called
- Profiles
- Advanced
- ans) Experts
- None
39) CLUSTER is a reserved Keyword in OWB
- ans) True
- FALSE
40) ROUND is a
- ans) Predefined Transformation
- Custom Transformation
- Both
- None
41) ALL_RT_AUDIT_LOCATIONS is
- API to create Locations
- ans) Locations Deployment Auditing View
- Locations Execution Auditing View
- None
42) ALL_IV_ALL_OBJECTS is a PUBLIC VIEW
- ans) True
- FALSE
43) deactivate_deployment script
- Deactivates a scheduled job
- ans) Deactivates a deployment job
- Deactivates an execution job
- None
44) service_doctor script
- Displays diagnostics about design center
- Displays diagnostics about the workflow manager.
- ans) Displays diagnostics about the Control Center repository and its
- service
- None
45) We can Schedule from SQL*PLUS
- OWB Mappings
- Process Flows
- ans) Both
- None
46) If a location cannot be unregistered using the Control Center Manager or an OMB*Plus
script then
- ans) Run the unregister_location script
- Delete Location
- Install Runtime Repository again
- None
47) OMB Plus, is an extension of
- Perl programming language
- ans) Tcl programming language
- Java programming language
- None
48) commands that comprise the OMB
Scripting Language are
- Metadata Manipulation Language (MML) Commands
- Shell Commands
- Administrative Commands
- ans) All of these
49) OMBCREATE command creates
- Modifies a first class object
- Retrieves information from a first class object
- ans) Creates a first class object
- None
50) OMBRETRIEVE is used to
- ans) Retrieve metadata of a component
- Retrieve location details
- Retrieve configuration details
- None
51) WB_IS_SPACE is
- ans) PreDefined Transformation
- Custom Transformation
- View
- None
52) We cannot import PL/SQL functions, procedures, and packages into a
Warehouse Builder project
- TRUE
- ans) False
53) OWB supports EXISTSNODE XML transformation
- ans) True
- FALSE
54) Oracle Warehouse Builder is Embedded in Oracle Database 11g and gets installed with database
- ans) True
- FALSE
55) Starting OWB 11g release SYSDBA Privileges No Longer Required for Installation
- ans) True
- FALSE
56) For OWB 11g release Oracle Workflow has to be installed separately
- TRUE
- ans) False
57) Workspaces are present in
- OWB 9i
- OWB 10gR2
- ans) OWB 11g
- None
58) OWB cannot be installed on RAC environment
- TRUE
- FALSE
- ans)
59) Below Strategies can be used for Managing Multiple Environments
- Multiple Environments Based on a Single Design Environment
- Multiple Environments Based on Multiple Design Environments
- ans) Both
- None
60) OWB 11g supports below Targets
- Oracle DB 8.1, 10.1, 10.2, 11.1
- Oracle DB 9.0, 10.1, 10.2, 11.1
- ans) Oracle DB 9.2, 10.1, 10.2, 11.1
- None
61) In OWB 11g Repository Browser Listener is started from command prompt
- ans) True
- FALSE
62) OWB 11g provides connector to Siebel
- ans) True
- FALSE
63) Below operator is used to Iterate through the values in the table type
- Table Operator
- Data Generator Operator
- ans) Varray Operator
- None
64) Below Display Set Includes only those attributes that are not connected to other attributes
- ALL
- MAPPED
- ans) UNMAPED
- None
65) Constant Operator is used to
- ans) Produce a single output group that can contain one or more constant attributes
- Produce a single output group that can contain one constant attributes
- Both
- None
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
- Direct PEL
- ans) Indirect PEL
- PEL
- None
67) Subprocess activity is used to
- ans) Embed an existing process flow within the process flow
- Call transformation in the process flow
- Both
- None
68) Repository Assistant is used to
- Create Repository
- Design center
- ans) define an Oracle Database as a Warehouse Builder
- repository
- None
69) Each repository
- must be associated with more than one repository owner
- ans) must be associated with at least one repository owner
- must be associated with one repository owner
- None
70) When we delete repository user from OWB
- ans) User gets deleted from Database
- User is deleted from OWB and database.
- Both
- None
71) Default role in OWB for users is
- All role
- ans) Everyone Role
- Administrator Role
- None
72) For taking backup in OWB we can use below methods
- Create Snapshots
- Take MDL backup
- ans) Both
- None
73) Warehouse Builder Repository Assistant logs are stored in below location
- ans) OWB_ORACLE_HOME\owb\UnifiedRepos\log_<timestamp>.log
- OWB_ORACLE_HOME\owb\log\Repository_Name\log.xx
- OWB_ORACLE_HOME\owb\log\Repository\log.xx
- None
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
- Metadata definitions
- ans) Metadata Dependency Manager
- Metadata configuration
- None
75) Core Functionality of OWB is?
- Design
- deployment
- management
- ans) All of these
76) Sources and targets are available in
- ans) Design Center
- Data Objects Editor
- Control Center
- None
77) OWB supports XML as target
- FALSE
- ans) True
78) Tables and Views are imported in ?
- Control Center
- Runtime Repository
- ans) Design Center
- None
79) Locations are used to store
- Database Objects
- ans) Connection Information
- Mappings
- process flows
80) We can create multiple projects in OWB
- ans) True
- FALSE
81) OWB supports below data model.
- Relational
- Dimensional
- ans) Both
- None
82) External Tables Represent
- Tables from databases other then Oracle
- ans) non-relational flat files in a relational format
- Both
- None
83) OWB supports CLOB data type
- ans) True
- FALSE
84) In OWB flat file can be used as
- Source
- Target
- ans) Both
- None
85) PIVOT is an operator in OWB
- ans) True
- FALSE
86) Pluggable Mapping Operator is used to
- As connection to other mappings
- Interface to external tables
- ans) Represents a reusable mapping
- All of these
87) We can Specify Target Load order in OWB
- FALSE
- ans) True
88) Process Flows can be used to
- Send Email notifications
- ans) Schedule mappings
- Both
- None
89) OWB can generate Code in
- PL/SQL
- SQL *Loader
- ABAP
- ans) All of these
90) Mappings can be developed in
- Design Center
- Control Center
- ans) Mapping Editor
- All of these
91) Mapping Editor can be used to Debug Mappings
- ans) True
- FALSE
92) Collections are used to
- Organize a large logical warehouse
- Validate and generate a group of objects
- ans) Both
- None
93) We cannot create Slowly Changing Dimensions in OWB
- ans) False
- TRUE
94) OMB Plus is
- Component of OWB
- ETL tool
- ans) scripting utility that enables to perform all operations available in the graphical user interfaces
- None
95) Module can correspond to
- Multiple locations
- ans) one location
- Both
96) We cannot delete
- The currently active or expanded project
- The only project in a repository
- ans) Both
- None
97) PEL stands for
- ans) Partition Exchange Loading
- Partition Extract Load
- Prepare Extract Load
- None
98) abort_exec_request script is used to
- Stop Service
- Kill OWB session
- ans) Stops an execution that is currently busy
- None
99) Sql*Plus can be used to schedule OWB jobs
- ans) True
- FALSE
100) Sorter Operator is
- Source and Target Operator
- ans) Data Flow Operator
- Pre/Post Processing Operator
- Pluggable Mapping Operator
101) Process Flows support
- For Loop
- While Loop
- ans) Both
- None
102) Mappings and Process Flows can be scheduled in
- ans) Design Center
- Control Center
- Data Objects Editor
- None
103) Repository Browser is used to
- Browse design metadata
- Audit Execution data
- Create Reports
- ans) All of these
104) Target Schema Contains
- Generated Code
- Mappings
- ans) Both
- None
105) OWB automatically creates a location for each user you register
- ans) True
- FALSE
106) Validation is the process of verifying metadata definitions and configuration
parameters
- FALSE
- ans) True
107) Below Data Object can be imported in OWB
- Dimensions
- Views
- ans) Both
- None
108) Canvas
- displays relational, objects
- ans) displays relational, dimensional, and
- business intelligence objects
- displays business intelligence objects
- None
109) The Data Viewer enables you to view the data stored in the data object
- FALSE
- ans) True
110) When you store dimension data in a relational form, you can implement the
dimension using
- Star Schema
- Snowflake Schema
- ans) Both
- None
111) In Below Operating Mode Warehouse Builder generates a single SQL statement that processes
all data and performs all operations
- Row based
- ans) Set based
- Set based fail over to row based
- None
112) Manual Commit is supported in OWB Mappings
- FALSE
- ans) True
113) Transform Activity is used in Process Flow to
- Transform Data
- ans) Add an existing transformation to the process flow
- Create new transformation
- None
114) Subprocess is used to Embed an existing process flow within the process flow
- ans) True
- FALSE
115) Benefits of using Transportable Modules are
- High Performance Data Extraction
- Distribute and Archive Datamarts
- Archive Sources
- ans) All of these
116) In Below Operating Mode Warehouse Builder generates a cursor select statement and attempts to include as many operations as possible in the cursor
- Row based
- Set based
- ans) Row based (Target Only)
- None
117) IN OWB Mappings we can have one Source and Multiple Targets
- ans) True
- FALSE
118) IN OWB Transformation Libraries can be accessed using
- Expression Builder
- Add Transformation Operator dialog
- Create Transformation Wizard
- ans) All of these
119) Constraints can be created using
- Design Center
- ans) Data Object Editor
- Control Center
- All of these
120) Below are runtime Parameters for Mappings
- Bulk Size
- Commit Frequency
- ans) Both
- None
121) Metadata Loader is used to
- populate a new repository as well as
- restore a backup of existing repository metadata
- populate a new repository as well as
- update, or restore a backup of existing repository metadata
- ans) populate a new repository as well as
- transfer, update, or restore a backup of existing repository metadata
- None
122) Design center is used for
- Designing
- Managing
- Scheduling
- ans) ALL
123) Repository browser can be used
- ans) To report on the metadata in the repository (
- To create the repository
- To design repository
- None of the above
124) Multiple target schema can be associated with single OWB repository
- ans) True
- FALSE
125) OWB repository can be hosted on Non oracle databases
- TRUE
- ans) False
126) Where can you register your locations
- Repository browse
- ans) Control center Service
- Target schema
- OWB repository
127) OWB mappings will be deployed in
- OWB repository
- Target schema
- Workspaces
- ans) Control center service
128) Set Operator in OWB supports
- Intersect
- Minus
- Union
- ans) All of the above
129) The default ‘Remaining_Rows’ group in Splitter can be removed
- TRUE
- ans) False
130) When you deploy a mapping you must generate
- ans) Runtime repository connection
- Designtime repository connection
- Both
- None of the above
131) Loading types of Oracle Target operator
- Delete
- Check/Insert
- Tuncate/Insert
- ans) All of the above
132) Which of the below loading type will append additional data to the target
- Check/Insert
- ans) Insert/Update
- All
- None
133) Match by constraint condition can be used in the Target operator to perform the below
- ans) Insert & Delete
- Insert/Update
- Both
- None
134) Which of the following mapping source operators are not supported when running mappings in debug mode.
- Advanced Ques
- Flat file
- Source table from an ABAP application
- ans) All
135) Data Generator operator can be used to generate
- RECNUM
- SYSDATE
- SEQUENCE
- ans) All of the above
136) Deduplicator can be used to Sort the records
- TRUE
- ans) False
137) Join condition expression cannot contain aggregation functions
- ans) True
- FALSE
138) It is possible to specify a full outer join in Joiner operator
- ans) True
- FALSE
139) You can pass external information to a mapping using parameter
- ans) True
- FALSE
140) Which of the below statement is true
- It is possible to send external values to a mapping
- It is possible to send out values from a mapping
- ans) A&B
- None
141) It is possible to call a procedure from expression operator
- ans) True
- FALSE
142) Possible Code generation options are
- Correlated Commit
- Optimized Code
- Bulk Processing Code
- ans) All of the above
143) Possible export options are
- Single mapping
- Multiple mappings
- Project
- ans) All of the above
144) Which is the scripting language used for OWB
- ans) OMB
- MDX
- MDL
- None of the above
145) It is possible to set processing order when you have multiple flows in the mapping
- TRUE
- ans) False
146) File extension of Mapping export is
- .OWB
- ans) .MDL
- .SQL
- .MDX
147) Oracle Warehouse Builder is used as a tool to implement which one of the below solution?
- Integrating the Data
- Extraction, Transformation & Loading
- Data Quality & Consolidation
- ans) All of Above
148) Oracle Warehouse Builder uses which functionality to Access numerous third-party databases, applications, files, and
data stores?
- Application Links
- Database Links
- Heterogeneous Services
- ans) Server Links
149) Which one is not a Oracle Warehouse Builder Component?
- Control Center Manager
- Warehouse Builder Repository
- Work Spaces
- ans) Session Manager
150) Which one is not a Warehouse Builder Client Side Component?
- Repository Browser
- Design Center
- Control Center Manager
- ans) Work Spaces
151) Physical properties of the object can be set
- While Deploying the Data Objects
- While Validating the Data Objects
- ans) Set by Configuring the Data Objects
- None of the Above
152) Oracle Warehouse Builder Generates the code of
- SQL
- ans) PL/SQL
- JAVA
- C++
153) Mapping Editor enables you to define
- Work Flow Visually
- ans) Data Flow Visually
- Session Flow Visually
- All of Above
154) OWB Logging Preferences enables you to set
- OWB Login Parameters
- Database Login Parameters
- ans) Log File Options
- All of Above
155) Which one is not a type of Location in OWB
- Databases
- Applications
- Files
- ans) Schema
156) Where to Create a Location in OWB ?
- Open Location Explorer, Locations Node
- Open Project Explorer, Locations Node
- ans) Open Connection Explorer, Locations Node
- None of Above
157) Steps to Import Metadata into OWB ( Assume that Project, Location, Module is created and configured properly)
- Right click on Location and Select Import, follow instructions in the Wizard
- ans) Right click on Module and Select Import, follow instructions in the Wizard
- Right click on Project and Select Import, follow instructions in the Wizard
- All of Above
158) Error Table Name option for a Table configuration indicates the name of the
- ans) Table name stores the rows that were not loaded into the table during a load operation.
- Table name stores the rows that were not loaded into all of the tables in the mapping during a load operation.
- Table name stores the rows that were not loaded into the tables in all of the mappings during a load operation.
- All of Above
159) Which one from below list is not an OWB OPERATOR?
- ans) Router
- Sorter
- Key lookup
- Match Merge
160) Key Lookup operator can perform lookup of data on
- ans) Tables , Views, Dimensions, Cubes
- Tables , Views, Dimensions
- Tables , Views
- Tables
161) Splitter operator does
- Splits a single column set into several output column sets using a Boolean split condition
- ans) Splits a single input row set into several output row sets using a Boolean split condition
- Splits a several input row set into several output row sets using a Boolean split condition
- All of Above
162) To call the PL/SQL Function or Stored Procedure which operators should be used
- Transformation or Table Function
- Expression or Table Function
- Transformation or Expression or Table Function
- ans) Transformation or Expression
163) Match and Merge is
- ans) OWB Data quality operator that identifies matching records and merges them into a single record
- OWB functionality that identifies multiple data objects and merges them into a single data object
- OWB component that identifies multiple work flow objects and merges them into a single work flow object
- None of above
164) OMB Plus is a
- ans) Scripting Interface for OWB
- Connection Interface for OWB
- Connection Interface for OWB
- None of Above
165) Pre/Post Processing Operators are
- ans) perform processing before or after executing a mapping
- perform processing before or after loading the data into a Target table
- perform processing before or after selecting the data from a Source table
- All of Above
166) The pivot operator enables or used to
- ans) transform a single row of attributes into multiple rows.
- transform a multiple rows of attributes into single row.
- transform a multiple table rows of data into single table row.
- None of above
167) Re-Usability can be implemented using which OWB Operator
- ans) Pluggable Mapping Operators
- Mapplets
- Table Function Operator
- All of Above
168) Target Load Order is used to specify
- Mappings load ordering within a work flow
- ans) Tables load ordering within a mapping
- Tables load ordering across all mappings
- None of above
169) Operator Wizards in the mapping editor will
- ans) Guide to define or usage of the operator in a mapping
- Create a new custom operator to use in the mapping
- Create a new re-usable custom operator to use in all projects
- None of Above
170) Which of the OWB component used for Profiling and analyzing quality of the data
- ans) Data Profile Editor
- Data Quality Editor
- Data Analysis Editor
- None of Above
171) Which one from below list is not a deployment action in OWB Deployment Process
- Create
- Upgrade
- Drop
- ans) Merge
172) OWB Naming Preferences enables to set
- ans) objects in business or physical name mode
- Objects Naming Standards
- Session and Project Naming Standards
- All of Above
173) Name and Address is
- A Module in OWB should be used for Identifies and corrects errors and inconsistencies in name and address source data.
- A Type of Connection in OWB should be used for Identifies and corrects errors and inconsistencies in name and address source data.
- ans) A Operator in OWB should be used for Identifies and corrects errors and inconsistencies in name and address source data.
- None of Above
174) Synchronizing From a Workspace Object to an Operator is used for
- ans) When you make changes to an workspace object in a module, you may want to propagate those changes to its corresponding mapping operator
- When you make changes to an operator in a mapping, you may want to propagate those changes to its corresponding workspace definition
- When you make changes to Table operator in a mapping, you may want to propagate those changes in the corresponding view object.
- All of Above.
175) Synchronizing from an Operator to a Workspace Object is used for
- ans) When you make changes to an operator in a mapping, you may want to propagate those changes to its corresponding workspace definition
- When you make changes to an workspace object in a module, you may want to propagate those changes to its corresponding mapping operator
- When you make changes to Table operator in a mapping, you may want to propagate those changes in the corresponding view object.
- All of Above.
176) Which one is not a Matching Strategy while synchronizing ?
- Match by Object Identifier
- Match by Bound Name
- Match by Position
- ans) Match by Sequence
177) A process flow describes dependencies between
- ans) Warehouse Builder mappings and external activities such as email, FTP, and operating system commands.
- Oracle Warehouse Builder mappings only
- Oracle Warehouse Builder Sessions only
- None of Above
178) Define the use of transitions in Work flow
- ans) to indicate the sequence and conditions in which activities occur in the process flow
- to indicate the sequence and conditions in which operators should execute in the process flow
- to indicate the sequence and conditions in which mappings should execute in the process flow
- all of above
179) OWB Locations enables you to
- ans) store the connection information to the various files, databases, and applications
- store the metadata from the various files, databases, and applications
- store the datafrom the various files, databases, and applications
- None of Above
180) You can embed commit logic ingo PL/SQL mapping using
- Expression Operator
- ans) PRE or POST Mapping Operator
- Pivot Operator
- Sorter Operator
181) One of the following is Invalid Operating Mode in PL/SQL mapping
- Set Based
- Row based
- Set based fail over to row based
- ans) Bulk Loading
182) Connector between a Schema nd Operating System is implemented via
- Oracle DB Link
- ans) Database Directory
- Symbolic Link
- None of the above
183) One of the following is not a valid transformation
- ans) Trigger
- Function
- Procedure
- Package
184) “Target Load Order” proprety in mapping configuration applies to
- Mapping with Single target
- ABAP Mapping
- Mapping with SQL * Loader
- ans) None of the above
185) One of the following is InValid OWB Operator
- Key Lookup Operator
- Materialized View Operator
- Cube Operator
- ans) Object Type Operator
186) When Synchronizing an operator in a mapping with a repository Object using “Object Identfier” we can match :
- Objects with different Type
- ans) Objects of Same Type
- Objects with Same Name
- None of the above
187) The following Runtime cannot be overridden when a mapping is executed
- Bulk Size
- Commit Frequency
- ans) Target Load Order
- Maximum Number of Errros
188) Find the Invalid Loading Type Property for Oracle Target Operator
- ans) Conventional Path Load
- Update/Insert
- None
- Truncate/Insert
189) Deleting a Location which is registered to use in control center
- Right click the Location and select Delete
- Right Click the Location in Design Center and click Unregister and then perform Delete
- ans) Right Click the Location in Control Center and click Unregister and then perform Delete in Design Center
- Not Possible to Delete a Location
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
- ans) ABAP
- PERL
- Java
- JavaScript
191) The following is not a source or Target Operator
- Cube Opeartor
- Varray Iterator
- Data Generator
- ans) Filter Operator
192) Pluggable Mapping Operator is
- ans) Represents a reusable mapping.
- A combination of input attributes that flow into the
- pluggable mapping.
- A combination of output attributes that flow out of the
- pluggable mapping.
- None of the above
193) When a mapping is deployed, the PLSQL code is
- ans) Deployed in Target Schema
- Deployed in Source Schema
- Deployed into OWB Repository
- None of the above
194) Default property of “Commit Control” Property of a mapping
- Manual
- Automatic Correlated
- ans) Automatic
- None of the above
195) Setting “Optimized Code” to TRUE
- Generates Optimized code for single table insert
- ans) generates a Multi Table insert SQL statement
- Generates Separate Insert statements for multi target mapping
- None of the above
196) Flat file as source, OWB generates
- ans) SQL * Loader Control file to load the data
- Generates script to parse the File and Load the data
- Generates Java Code to process the flat file
- None of the above
197) Flat File as Target, for this mapping the “Language” has a Valid Value of
- SQL * Loader
- PL/SQL
- ABAP
- ans) All of the above
198) Flat File as Target, Code is generated for this mapping only when “Default Operating” value is
- Set Based
- Row based
- ans) Row based(target only)
- all of the above
199) In process flow, the activity property “Remote Location” is used for
- ans) FTP
- Target Database
- File
- all of the above
200) In process flow, the activity property “Working Location” is used for
- FTP
- FILE EXISTS
- External Process
- ans) all of the above
201) Which SCD’s are supported by OWB as part of Enterprise ETL mappings?
- Creating Slowly Changing Dimension Type 2
- Creating Slowly Changing Dimension Type 3
- ans) Creating Slowly Changing Dimension Type 2&3
- None of the above
202) Does OWB support XML files as Target
- ans) True
- FALSE
203) What are locations?
- Physical definations of storage areas
- Logical Storage schema location
- Physical storage area location
- ans) Logical definations of storage areas.
204) The runtime repository is the place where OWB keeps all the required information about deployment and execution of ETL procedures.
- FALSE
- ans) True
205) A design repository where ETL procedures and related objects are modeled on a logical level.
- ans) True
- FALSE
206) What does OWB Connector E-Business Suite provide access to
- Only Technical Metadata
- Only Business Metadata
- ans) Both Technical & Business Metadata
- None of the above
207) What are the two main execution modes and variants supported by execution engine?
- Set Based and Rule Based
- Rule Based and Run Based
- ans) Set based and Row based
- Rule based and Schedule based
208) Is Row based execution mode is better than Set based?
- FALSE
- ans) True
209) The information displayed through a Design center is actually stored in one of the following places.
- Target Database
- ans) OWB Workspace/Metadata Repository
- Source Database
- None
210) What are the possible source operators for OWB map.
- ans) Table
- Flat File
- Materialized views
- All
211) An OWB Map can be executed in the following Modes
- Set Based
- Row Based
- Set Based Failover to Row Based
- ans) All
212) Insert/Update Type used the following SQL operation
- First Insert then Update
- First Update then Insert
- ans) Merge
- None
213) You found a small mistake in a deployed map. In order to correct It what you should do.
- ans) Correct it in the mapping editor
- Correct it in the database PLSQL package
- Both
- None
214) A map which loads data from a file to a database table generates the following type of code
- ans) SQL Loader Script
- PLSQL Package
- SQL Code
- All
215) For a SQL Loaded Type of MAP which one should be used to generate sequential numbers.
- Mapping Sequence
- ans) Data Generator
- Procedure
- None
216) In a process flow, to run a unix script which operator you will use.
- Sub process
- ans) External Process
- Forking Process
- All
217) An object can be deployed through which editor
- Design Center
- Control Center
- ans) Both
- None
218) Which one of the following is true for a Collection.
- It creates a copy of an object in the named collection
- ans) it creates a shortcut of the objects in the named collection
- It creates new objects in the named collection
- All
219) A Set operator can perform the following functions
- Union
- Union All
- Minus
- ans) All
220) Which one is a data quality operator in OWB
- Post Mapping Process
- Pivot
- ans) Match and Merge
- All
221) Process Flow generates the following type of codes
- PLSQL Code
- ans) XML Code
- Perl Script
- Java Code
222) A Post Map can be triggered on which condition
- Success of a map
- Failure of a Map
- Warning of a Map
- ans) All
223) A Commit Frequency can be set in one of the following place in a Map
- Target Property
- ans) Mapping Configuration Run time Property
- Target Database
- All
224) Where do you created the definition of external tables
- ans) Design Center/OWB Client
- Target Database
- Source Database
- All
225) A connector implemented in database can be a
- A dblink
- A directory
- ans) both
- None
226) A Map can execute the following objects
- Package
- Procedure
- Function
- ans) All
227) Which of the following operations can not be done on the target table in a map.
- Delete/Insert
- Truncate/Insert
- ans) select
- Update
228) The same table can be used as both source and target
- Same table can not be used for both.
- ans) Yes, it can be used without any problem.
- It can be theoretically possible but generates erroneous results.
- None
229) You have modified the table definition in OWB. If you want to use new definition in a existing map what you will do.
- ans) Reconcile Inbound
- Reconcile Outbound
- Create a new Map
- None
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
- Based on Primary Key
- Based on unique key
- ans) Both
- None
231) SCD2 type of maps can be developed using OWB
- OWB does not support SCD2
- ans) SCD2 can be implemented using a combination of operators.
- SCD2 can only be implemented by writing PLSQL code not by operator
- None
232) An OWB map can be executed in which of the following way
- Using Process Flow
- Using Deployment Manager/Control Center
- Using PLSQL script
- ans) All
233) If a Map fails due to reaching maximum number of error set in the configuration, how do you find out those erroneous records.
- Querying in Target database
- ans) Querying in OWB Repository
- Write a special package to capture them.
- There is no way to find those records.
234) Oracle allows to view OWB repository and run time data in the following way.
- Self Made SQL
- Repository Browser based reports.
- ans) Both
- None
235) One important new feature in OWB 11g
- Match and Merger
- ans) Date Watch and Repair
- Name and Address
- Unpivot
236) What operator should be used for generate sequential number for a SQL Loader Script
- Sequence Generator
- ans) Data Generator
- Procedures
- None
237) Which one is a data quality operator
- Filter Operator
- Transformation Operator
- ans) Match and Merge
- None
238) While proposing OWB as an ETL tool to customer which one of the following is the most important point for consideration.
- Volume of incremental data is very high.
- ans) Target is an Oracle Database
- Source as SAP R/3
- All
239) Snapshot is taken for
- Debugging
- Security
- ans) Change Management
- None
240) Which one of the following is a performance tuning feature in OWB
- Filter Operator
- Using TRUNCATE/INSERT in Target table
- ans) Using database hint.
- SET Operator
241) if OWB maps fails on reaching max error where do you find erroneous records
- In target schema
- ans) In OWB Runtime Repository
- In Source Database
- All
242) How can you run/execute OWB maps
- Using DBMS_JOB/Schedule
- Using Procedures
- Using Processflow
- ans) ALL
243) In database how OWB Bulk Processing works.
- It uses only database cursor based operation
- It generates code which is similar like “insert into table2 (select * from table1”
- ans) It uses both cursor and array/table type variable.
- None
244) How do you set correlated commit in a Map
- ans) In Mapping configuration parameter
- In process flow parameters
- In target parameter
- ALL
245) In which of the following cases you would correct the code in the OWB deployed PLSQL package.
- To correct proper MERGE operation.
- To add a hint in target table
- To force a certain type of operation like ROW/SET based.
- ans) There would be no such cases when you need to correct in generated PLSQL Package.
246) How do perform tune a OWB Map
- Setting operation Mode ROW/SET based.
- Placing SQL and PLSQL operators wisely.
- Setting Analyze table option to ‘TRUE”
- ans) All
247) Where do you deploy SQLLoader Script
- In Target Schema
- In Source Schema
- ans) In file system
- in Processflow.
248) Which one is a maintenance task in an existing OWB environment
- Gradually reducing volume of source data
- Changing configuration parameters
- ans) purging runtime repository
- All
249) Which one of the following action will recover your OWB project from database crash.
- Recovering Target database from backup.
- ans) Recovering OWB repository schema from backup.
- Installing fresh OWB repository.
- All
250) Following process can be used for version control inside OWB.
- Snapshot
- Collection
- Export .mdl file
- ans) All
251) If a Map is executed using processflow where do you set the runtime parameters.
- In the configuration parameter of the map
- ans) In the processflow parameters for a Map
- In the database after deploying the map.
- None
252) How do you restore execution plan for a OWB Map.
- By redeploying the same map.
- ans) It can only be done in target database by restoring statistics.
- Restarting the database.
- None
253) While creating Runtime repository, do OWB create objects in the following schema.
- ans) Both in OWB Repository and target schema
- Only in OWB repository schema.
- Both Source and Target schema.
- In all schemas Source,Target and OWB repository.
254) Which one of the following may generate an outer Join.
- Unpivot Operator
- Join Operator with all inner Joins
- ans) Splitter Operator
- Keylook Up Operator
255) How does a CONSTANT operator gets implemented inside the package
- Constant values need to be passed from outside the map.
- No Code is generated for a Constant
- ans) Mainly as a select from Oracle Dual table.
- None
256) Which one of the following are allowed only once in a Map
- Pre-Mapping Operator
- Post-Mapping Operator
- Operator Mapping Input Parameter
- ans) All
257) If using a 3rd Party configuration tool which one of the following is a must.
- Ensuring Database Package generated by OWB is version controlled
- ans) Ensuring OWB Objects (Maps, Process Flows etc) are version controlled
- 3rd Party Change Management tool can not perform configuration management for OWB.
- None