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

1. Question 83: Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)
2. Question 84: Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
3. Question 85: Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)
4. Question 86: Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)
5. Question 87: Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery are…
6. Question 88: Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)
7. Question 89: The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which t…
8. Question 90: Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)
9. Question 91: Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)
10. Question 92: Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard…