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

1. Question 93: Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install t…
2. Question 94: Which two are true about RMAN Multisection backups when a very large data file is divided into four sections? (Choose two.)
3. Question 95: Which three are true about the Oracle Optimizer? (Choose three.)
4. Question 96: RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between…
5. Question 97: You plan to perform cross-platform PDB transport using XTTS. Which two are true? (Choose two.)
6. Question 98: Which three true about recovering tables using RMAN? (Choose three.)
7. Question 99: Which operating system group is NOT needed to perform an Oracle Database installation?
8. Question 100: You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destinatio…
9. Question 102: Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)
10. Question 103: Which three are true about SGA memory management in a multitenant database? (Choose three.)