Oracle Database 12c: Advanced Administration Free Practice Exam Questions

177 real Oracle Database 12c: Advanced Administration exam questions with answers and AI explanations. Oracle certification prep — page 2 of 18.

1. Question 12: Which two statements are true about RMAN duplexed backups?
2. Question 13: Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using R…
3. Question 14: You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD…
4. Question 15: Which two statements are true about roles in multitenant container databases (CDBs)?
5. Question 16: Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10…
6. Question 17: Which two statements are true about encrypted backups performed by using RMAN?
7. Question 18: You execute the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2; RMAN> CONFIGURE CHANNEL 1 DEVICE TY…
8. Question 19: Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open?
9. Question 20: Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIV…
10. Question 21: Which three statements are true about Flashback Data Archive?