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

  1. Question 126: Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
  2. Question 127: Which two statements are true about making RMAN image copies of a database?
  3. Question 128: You are connected to a recovery catalog and target database. You execute the command: RMAN> CATALOG START WITH /disk1/backups; Which statement is true?
  4. Question 130: Which two are benefits of unified auditing in full mode?
  5. Question 131: Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
  6. Question 132: You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance b…
  7. Question 133: One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2. You connect to PDB2 as a common user with DBA p…
  8. Question 134: You issued these commands for one of your databases: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; RMAN> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE "˜…
  9. Question 135: You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PA…
  10. Question 136: You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs - DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and y…