Oracle Warehouse Builder | OWB Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
2) OWB Supports Split Repositories Implementation

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
3) OWB can be installed on below platforms

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
4) If you plan to use Warehouse Builder process flows,
you need to install Oracle Workflow to enable
deployment.

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
5) Before installing OWB Oracle Database should be installed

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
9) Oracle database user can created from OWB.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
11) Below are Object Privileges for User.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
12) CREATE_PROJECT is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
13) Warehouse Builder enables multiple users to access the same Warehouse Builder
repository

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
18) We can create below partitions in OWB

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
19) In Table configuration Logging mode can be set to

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
20) Materialized Views can be configured in OWB

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
21) Dimensions can edited from OWB using

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
23) OWB supports Cube creation

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
24) Cubes that use a MOLAP implementation are stored in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
27) Oracle Designer objects can be used as source in
Warehouse Builder

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
28) MIMB stands for

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
32) Below are Data Quality Operators

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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
  4. Both
  5. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
35) Audit Reports can be viewed from

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
37) OMB Plus provides the following commands to export metadata

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
38) Design solutions that
simplify routine tasks and implement best practices are called

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
39) CLUSTER is a reserved Keyword in OWB

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
40) ROUND is a

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
41) ALL_RT_AUDIT_LOCATIONS is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
42) ALL_IV_ALL_OBJECTS is a PUBLIC VIEW

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
43) deactivate_deployment script

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
45) We can Schedule from SQL*PLUS

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
47) OMB Plus, is an extension of

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
50) OMBRETRIEVE is used to

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
51) WB_IS_SPACE is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
52) We cannot import PL/SQL functions, procedures, and packages into a
Warehouse Builder project

  1. TRUE
  2. ans) False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
53) OWB supports EXISTSNODE XML transformation

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
54) Oracle Warehouse Builder is Embedded in Oracle Database 11g and gets installed with database

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
55) Starting OWB 11g release SYSDBA Privileges No Longer Required for Installation

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
56) For OWB 11g release Oracle Workflow has to be installed separately

  1. TRUE
  2. ans) False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
57) Workspaces are present in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
58) OWB cannot be installed on RAC environment

  1. TRUE
  2. FALSE
  3. ans)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
61) In OWB 11g Repository Browser Listener is started from command prompt

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
62) OWB 11g provides connector to Siebel

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
64) Below Display Set Includes only those attributes that are not connected to other attributes

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
71) Default role in OWB for users is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
72) For taking backup in OWB we can use below methods

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
75) Core Functionality of OWB is?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
76) Sources and targets are available in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
77) OWB supports XML as target

  1. FALSE
  2. ans) True

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
78) Tables and Views are imported in ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
79) Locations are used to store

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
80) We can create multiple projects in OWB

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
81) OWB supports below data model.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
83) OWB supports CLOB data type

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
84) In OWB flat file can be used as

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
85) PIVOT is an operator in OWB

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
87) We can Specify Target Load order in OWB

  1. FALSE
  2. ans) True

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
88) Process Flows can be used to

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
89) OWB can generate Code in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
90) Mappings can be developed in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
91) Mapping Editor can be used to Debug Mappings

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
92) Collections are used to

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
93) We cannot create Slowly Changing Dimensions in OWB

  1. ans) False
  2. TRUE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
95) Module can correspond to

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
96) We cannot delete

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
97) PEL stands for

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
99) Sql*Plus can be used to schedule OWB jobs

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
100) Sorter Operator is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
101) Process Flows support

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
102) Mappings and Process Flows can be scheduled in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
103) Repository Browser is used to

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
104) Target Schema Contains

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
105) OWB automatically creates a location for each user you register

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
106) Validation is the process of verifying metadata definitions and configuration
parameters

  1. FALSE
  2. ans) True

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
107) Below Data Object can be imported in OWB

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
108) Canvas

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
109) The Data Viewer enables you to view the data stored in the data object

  1. FALSE
  2. ans) True

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
112) Manual Commit is supported in OWB Mappings

  1. FALSE
  2. ans) True

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
114) Subprocess is used to Embed an existing process flow within the process flow

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
117) IN OWB Mappings we can have one Source and Multiple Targets

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
119) Constraints can be created using

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
120) Below are runtime Parameters for Mappings

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
122) Design center is used for

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
124) Multiple target schema can be associated with single OWB repository

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
125) OWB repository can be hosted on Non oracle databases

  1. TRUE
  2. ans) False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
126) Where can you register your locations

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
127) OWB mappings will be deployed in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
128) Set Operator in OWB supports

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
129) The default ‘Remaining_Rows’ group in Splitter can be removed

  1. TRUE
  2. ans) False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
131) Loading types of Oracle Target operator

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
135) Data Generator operator can be used to generate

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
136) Deduplicator can be used to Sort the records

  1. TRUE
  2. ans) False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
137) Join condition expression cannot contain aggregation functions

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
138) It is possible to specify a full outer join in Joiner operator

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
139) You can pass external information to a mapping using parameter

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
141) It is possible to call a procedure from expression operator

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
142) Possible Code generation options are

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
143) Possible export options are

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
144) Which is the scripting language used for OWB

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
145) It is possible to set processing order when you have multiple flows in the mapping

  1. TRUE
  2. ans) False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
146) File extension of Mapping export is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
152) Oracle Warehouse Builder Generates the code of

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
153) Mapping Editor enables you to define

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
155) Which one is not a type of Location in OWB

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
159) Which one from below list is not an OWB OPERATOR?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
171) Which one from below list is not a deployment action in OWB Deployment Process

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
183) One of the following is not a valid transformation

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
188) Find the Invalid Loading Type Property for Oracle Target Operator

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
191) The following is not a source or Target Operator

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
194) Default property of “Commit Control” Property of a mapping

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
202) Does OWB support XML files as Target

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
205) A design repository where ETL procedures and related objects are modeled on a logical level.

  1. ans) True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
208) Is Row based execution mode is better than Set based?

  1. FALSE
  2. ans) True

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
210) What are the possible source operators for OWB map.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
212) Insert/Update Type used the following SQL operation

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
217) An object can be deployed through which editor

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
219) A Set operator can perform the following functions

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
220) Which one is a data quality operator in OWB

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
221) Process Flow generates the following type of codes

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
224) Where do you created the definition of external tables

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
225) A connector implemented in database can be a

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
226) A Map can execute the following objects

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
235) One important new feature in OWB 11g

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
237) Which one is a data quality operator

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
239) Snapshot is taken for

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
242) How can you run/execute OWB maps

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
247) Where do you deploy SQLLoader Script

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
250) Following process can be used for version control inside OWB.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz