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 3 of 22.

  1. Question 22: 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.)
  2. Question 23: You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)
  3. Question 25: Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)
  4. Question 26: Backup requirements for a database: * Level 0 backup on Sunday * Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday * Differential increm…
  5. Question 27: You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you en…
  6. Question 28: Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDI…
  7. Question 29: Which statement is true about the Oracle central inventory directory (oraInventory)?
  8. Question 30: You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?
  9. Question 31: Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)
  10. Question 33: Which statement is true about the loss of a data file belonging to the default undo tablespace?