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

  1. Question 53: You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next?
  2. Question 54: Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS); 2. S…
  3. Question 55: Database? (Choose two.)
  4. Question 56: You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which m…
  5. Question 57: Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years. Three years later, it is decided…
  6. Question 58: You execute the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2; RMAN> BACKUP DATABASE; Which two sta…
  7. Question 59: Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)
  8. Question 60: Which two are prerequisites for setting up Flashback Data Archive?
  9. Question 61: 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 62: Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?