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

  1. Question 174: Examine the following command: SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command?
  2. Question 175: Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
  3. Question 176: Which two statements are true about resumable space allocation? (Choose two.)
  4. Question 177: Identify three uses of the CROSSCHECK command (Choose three.)
  5. Question 178: Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.
  6. Question 179: Which task is performed by a background process in a database instance?
  7. Question 180: Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
  8. Question 181: Which users are created and can be used for database and host management of your DBaaS database servers?
  9. Question 182: You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?
  10. Question 183: Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?