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

1. Question 22: Which three types of backups can be performed for a database running in NOARCHIVELOG mode?
2. Question 23: You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
3. Question 24: For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace. You execute the…
4. Question 25: Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption…
5. Question 26: Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are…
6. Question 27: You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database…
7. Question 28: Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected…
8. Question 29: You execute the RMAN commands: RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST; Which task is performed by these commands?
9. Question 30: Which two are prerequisites for creating a backup-based duplicate database?
10. Question 31: Which two statements are true about a common user?