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 1 of 18.

  1. Question 1: You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the foll…
  2. Question 2: Examine the RMAN commands executed in your database: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RK…
  3. Question 3: Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing…
  4. Question 4: Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?
  5. Question 5: You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the T…
  6. Question 6: Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests?
  7. Question 7: You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT. Examine the comm…
  8. Question 9: Which three statements are true about the database instance startup after an instance failure?
  9. Question 10: Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode?
  10. Question 11: Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?