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

1. Question 12: Which two are true about the character sets used in an Oracle database? (Choose two.)
2. Question 13: Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
3. Question 14: A user complains about poor database performance. You want to verify if the user's session has waited for certain types of I/O activity. Which view displays al…
4. Question 15: You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination p…
5. Question 16: Which three are true about Optimizer Statistics Advisor? (Choose three.)
6. Question 17: You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)
7. Question 18: Which three are true about monitoring waits for sessions and services? (Choose three.)
8. Question 19: Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
9. Question 20: Examine this command: $ rhpctl move database `"sourcehome Oracle_home_path `"destinationhome Oracle_home_path For which two purposes can you use this command?…
10. Question 21: Which three are true about opatchauto? (Choose three.)