0
Alien head

platforms and products Online Quiz - 36

Description: platforms and products Online Quiz - 36
Number of Questions: 20
Created by:
Tags: platforms and products

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

Answer: 3

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

Answer: 4

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

Answer: 2

Oracle Inventory allows Subinventory Deletion provided...

  1. No Items and OnHand Quantities

  2. No Locators Tagging

  3. No Open Transactions

  4. All the Above

Answer: 4

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

Answer: 3

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

Answer: 3

Can Warehouse Builder ensure referential integrity in the warehouse?

  1. Yes

  2. No

  3. Can't say

  4. Actually Both

Answer: 1

Which among these is NOT a warehouse builder service?

  1. Import

  2. Export

  3. Generate

  4. Execute

Answer: 2

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

Answer: 4

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

Answer: 4

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

Answer: 3

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

Answer: 2

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

Answer: 2

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

Answer: 3

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

Answer: 1

What client platforms are supported for Warehouse Builder 9.2?

  1. Windows

  2. Sun Solaris

  3. Linux

  4. All of the above

Answer: 2

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

Answer: 4

Which of the following transformations can be performed by owb ?

  1. Data cleansing

  2. Invoke stored procedure

  3. Filters

  4. All of the Above

Answer: 4

Which of the following ERP Applications is supported by OWB?

  1. SAP R/3

  2. J.D.Edwards

  3. Peoplesoft

  4. Baan

Answer: 1

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

Answer: 3
+ View questions