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 4 of 17.

  1. Question 35: Which three are true about Database Point-in-Time Recovery? (Choose three.)
  2. Question 36: Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background p…
  3. Question 37: Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)
  4. Question 38: Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
  5. Question 39: Which two are true about instance recovery? (Choose two.)
  6. Question 40: Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
  7. Question 41: Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
  8. Question 42: Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
  9. Question 43: Which three are true about managing memory components in an Oracle database instance? (Choose three.)
  10. Question 44: Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)