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

1. Question 23: Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)
2. Question 24: Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, the…
3. Question 25: Which two are true about RMAN duplexed backup sets? (Choose two.)
4. Question 27: Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
5. Question 29: Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
6. Question 30: A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of…
7. Question 31: Which three are true? (Choose three.)
8. Question 32: Which three are true about performing an Oracle Database install on Linux? (Choose three.)
9. Question 33: Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
10. Question 34: A database is configured in ARCHIVELOG mode. Full RMAN backups are taken daily and no backup to trace has been taken of the control file. A media failure has o…