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

1. Question 114: Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
2. Question 115: Examine this configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1. 3. Redo log g…
3. Question 116: Which three are true about an application container? (Choose three.)
4. Question 117: Which three are true about patchsets? (Choose three.)
5. Question 118: HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An app…
6. Question 119: Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)
7. Question 120: You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true? (Choose three.)
8. Question 121: Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
9. Question 123: Which two are true about RMAN backups when using a media manager? (Choose two.)
10. Question 124: Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.)