1. How can a cross product be created?

ANS:- By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.

2. How can a group in a cross products be visually distinguished from a group that does not form a cross product?

ANS:- A group that forms part of a cross product will have a thicker border.

3. At least how many set of data must a data model have before a data model can be base on it?

ANS:- Four.

4. Is it possible to have a link from a group that is inside a cross product to a group outside ? (Y/N)

ANS:- No.

5. Is it possible to link two groups inside a cross products after the cross products group has been created?

ANS:- No.

6. What is an user exit used for?

ANS:- A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back
to Oracle reports.

7. What are the three types of user exits available ?

ANS:- Oracle Precompiler exits, Oracle call interface,NonOracle user exits.

8. How can values be passed between precompiler exits & Oracle call interface?

ANS:- By using the statement EXECIAFGET & EXECIAFPUT.

9. How can I message to passed to the user from reports?

ANS:- By using SRW.MESSAGE function.

Oracle DBA:-

1. SNAPSHOT is used for
[DBA] a] Synonym, b] Table space, c] System server, d] Dynamic data replication
Ans : D

2. We can create SNAPSHOTLOG for
[DBA] a] Simple snapshots, b] Complex snapshots, c] Both A & B, d] Neither A nor B
Ans : A

3. Transactions per rollback segment is derived from
[DBA] a] Db_Block_Buffers, b] Processes, c] Shared_Pool_Size, d] None of the above
Ans : B

4. ENQUEUE resources parameter information is derived from
[DBA] a] Processes or DDL_LOCKS and DML_LOCKS, b] LOG_BUFFER, c] DB__BLOCK_SIZE..
Ans : A

5. LGWR process writes information into
a] Database files, b] Control files, c] Redolog files, d] All the above.
Ans : C

6. SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Table space
a] True, b] False
Ans : False

7. Databases overall structure is maintained in a file called
a] Redolog file, b] Data file, c] Control file, d] All of the above.
Ans : C

8. These following parameters are optional in init.ora parameter file
DB_BLOCK_SIZE, PROCESSES
a] True, b] False
Ans : False

9. Constraints cannot be exported through EXPORT command
a] True, b] False
Ans : False

10. It is very difficult to grant and manage common privileges needed by different groups of database users using the roles
a] True, b] False
Ans : False