Oracle Apps Technical MCQ

This Oracle Apps Technical MCQ Quiz contains few questions as a online practice test.

1. Which is not a correct concurrent program status?
a. Launch a URL
b. DO_KEY
c. Launch SRS form
d. Launch a function

2. Which of the following is not a validation type for Value Set
a. Independent
b. Dependent
c. table
d. Vector

3. You have been asked to define a data block based on a JOIN of multiple tables. The read-only data will be used for calculations and lookups. The DBA is on holiday and is unable to define a view on the database server. What is the simplest way for you to continue to build the form?
a. Define a data block based on a Ref Cursor
b. Define a data block based on a Table of Records
c. Define a data block based in a From Clause query
d. Define a data block based on a combination of Ref cusor and table of records

4. Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?
a. BINSIZE
b. ROWS
c. SKIP
d. LOAD

5. The result set of Cartesian product involving two tables with x and y number of rows will be _____ no. of rows
a. x+y
b. x*y
c. x-y
d. x*y-1