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?





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
  1. Deployment Manager

  2. Metadata Reporting Browser

  3. Runtime Repository

  4. Runtime Audit Browser

Correct Option: D

Can Warehouse Builder ensure referential integrity in the warehouse?

  1. Yes

  2. No

  3. Can't say

  4. Actually Both

Correct Option: A
  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
  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
  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