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

1. Question 57: You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or featu…
2. Question 58: Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
3. Question 59: Which two statements are true when row archival management is enabled? (Choose two.)
4. Question 60: Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?
5. Question 61: Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
6. Question 62: The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis. What is…
7. Question 63: Examine this command executed on a client that is remote from the database server. SQL> CONNECT hr/hr@orcl - Which two are required for this command to connect…
8. Question 64: Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)
9. Question 65: Examine this command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true? (Choose two.)
10. Question 66: Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?