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

1. Question 135: Which three are true about the FLASHBACK DATABASE feature? (Choose three.)
2. Question 136: Which two are true about backup set compression using RMAN default compression? (Choose two.)
3. Question 138: Which two are true about Optimizer Statistics? (Choose two.)
4. Question 139: A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?
5. Question 140: Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)
6. Question 141: Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)
7. Question 142: Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)
8. Question 143: A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine thi…
9. Question 144: Which two are true about Oracle instance recovery? (Choose two.)
10. Question 146: Which two are true about PDB archive files? (Choose two.)