0

platforms and products Online Quiz - 36

Description: platforms and products Online Quiz - 36
Number of Questions: 20
Created by:
Tags: platforms and products
Attempted 0/20 Correct 0 Score 0

Which of the following products is used for maintaining dependency management in owb ?

  1. OWB

  2. Oracle Enterprise Manager

  3. Oracle work flow

  4. Pure Extract


Correct Option: C

Which of the following ERP Applications is supported by OWB?

  1. SAP R/3

  2. J.D.Edwards

  3. Peoplesoft

  4. Baan


Correct Option: A

Which of the following transformations can be performed by owb ?

  1. Data cleansing

  2. Invoke stored procedure

  3. Filters

  4. All of the Above


Correct Option: D

Which of the following features can be used for flat files by owb?

  1. Character delimited

  2. fixed length

  3. single record

  4. All of the Above


Correct Option: D

What client platforms are supported for Warehouse Builder 9.2?

  1. Windows

  2. Sun Solaris

  3. Linux

  4. All of the above


Correct Option: B

Which is the flexible, high-level command line metadata access tool for Oracle9i Warehouse Builder?

  1. OMB Plus

  2. OWB Plus

  3. OMB Script

  4. OWB Metabase


Correct Option: A

Suppose an OWB map throws an error. Which audit view will show me that error message?

  1. ALL_RT_AUDIT_MAP_RUNS

  2. ALL_RT_AUDIT_MAP_RUN_ERRORS

  3. RAB_RT_EXEC_PROCESS_RUN_ERRORS

  4. RAB_RT_EXEC_ERROR_MSGS


Correct Option: C

Which type of SCD is ideal for a data warehousing project?

  1. Type 1

  2. Type 2

  3. Type 3

  4. All of the Above


Correct Option: B

Which of the following products is used for scheduling feature for running jobs at specified times ?

  1. Pure Integrate

  2. Oracle Enterprise Manager

  3. Pure Extract

  4. Oracle Work Flow


Correct Option: B

Which of the following operators in owb would you use to get Distinct data ?

  1. Distinct

  2. Unique

  3. Deduplicator

  4. No such operator exists


Correct Option: C

which of the built-in performance optimization techniques used during the ETL processing

  1. PL/SQL bulk Processing

  2. Foreign key constraint manipulation

  3. Inline View technique

  4. All of the Above


Correct Option: D

Which component of OWB enables user to view deployment and execution audit information?

  1. Deployment Manager

  2. Metadata Reporting Browser

  3. Runtime Repository

  4. Runtime Audit Browser


Correct Option: D

Which among these is NOT a warehouse builder service?

  1. Import

  2. Export

  3. Generate

  4. Execute


Correct Option: B

Can Warehouse Builder ensure referential integrity in the warehouse?

  1. Yes

  2. No

  3. Can't say

  4. Actually Both


Correct Option: A

Which of the following Integrator is used when OWB uses Flat Files as a Source System

  1. OWB Integrator for Sybase DB & Apps 3.0

  2. OWB Integrator for Oracle DB & Apps 3.0

  3. OWB Integrator for Flat Files

  4. OWB Integrator for SAP Applications 3.0


Correct Option: C

Does sales order import allows the creation of customer?

  1. Order Import does not support this feature.

  2. Only possible through Front End provided the Customer Profile for OM is Set at all levels.

  3. Order Import Supports Customer Creation, Contacts and Addresses.

  4. None


Correct Option: C

Oracle Inventory allows Subinventory Deletion provided...

  1. No Items and OnHand Quantities

  2. No Locators Tagging

  3. No Open Transactions

  4. All the Above


Correct Option: D

What are the mandatory setups to create a WIP job for an item?

  1. Check inventory item attribute only

  2. Check Build in WIP, Inventory Item attributes

  3. Check Bom Allowed, Inventory Item attributes

  4. Check Bom Allowed and Build In WIP attributes


Correct Option: B

Auto Lock Box Program in Receivables allows the following

  1. Create Cash Receipts

  2. Allow Bank Payments

  3. Allow Invoice and Receipt Matching

  4. All the Above


Correct Option: D

What is the expansion of TIBCO?

  1. Technology Information Bus Coporation

  2. The Intellectual Business Corporation

  3. The Information Bus Company

  4. The Interface Bus Company


Correct Option: C
- Hide questions