Oracle Database 12c: Installation and Administration Free Practice Exam Questions

211 real Oracle Database 12c: Installation and Administration exam questions with answers and AI explanations. Oracle certification prep — page 2 of 22.

  1. Question 11: Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)
  2. Question 12: Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified…
  3. Question 13: Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsin…
  4. Question 14: Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
  5. Question 15: In which situations does the Database Writer process (DBWn) write to data files? (choose two).
  6. Question 16: You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases both have their instances running. Which two…
  7. Question 17: You want to create a database and you have the following: - Oracle Grid Infrastructure is installed and configured. - Oracle Database Vault is installed in ORA…
  8. Question 18: Which statement is true about redo log files during instance recovery?
  9. Question 19: Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario? (Choose two.)
  10. Question 20: Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured. Loss of which t…