Below are the list of top 80 oracle dba multiple choice questions and answers for freshers beginners and experienced pdf. Oracle DBA Multiple Choice Questions and Answers 1.SNAPSHOT is used for_____ . 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 Tablespace A. True, B. False Ans : False 7.Databases overall structure is maintained in a fil...