Oracle Database Administration II Free Practice Exam Questions

161 real Oracle Database Administration II exam questions with answers and AI explanations. Oracle certification prep — page 6 of 17.

  1. Question 59: Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)
  2. Question 60: Which three are true about the SQL Tuning Advisor? (Choose three.)
  3. Question 61: Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)
  4. Question 62: Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)
  5. Question 65: Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)
  6. Question 66: Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery c…
  7. Question 67: Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
  8. Question 68: Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to con…
  9. Question 69: Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
  10. Question 70: Which three are true about Automatic Workload Repository (AWR)? (Choose three.)