Placement Papers - ORACLE

PAPER: ORACLE PLACEMENT PAPER (TECHNICAL- CROSS PRODUCTS AND MATRIX REPORTS & DBA)

 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