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

  1. Question 226: You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the fo…
  2. Question 227: Which statement is true regarding the startup of a database instance?
  3. Question 228: Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).
  4. Question 232: In your database, archive logging and control file autobackup are enabled. The data files and redo log files are intact but control files are impacted due to m…
  5. Question 233: Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty fil…
  6. Question 234: You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing com…
  7. Question 235: Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)
  8. Question 236: Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. Yo…
  9. Question 237: Your database is open in read/write mode and multiple users are connected to the database instance. You execute the following command: SQL> ALTER SYSTEM ENABLE…
  10. Question 238: In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic Workload Repository (AWR) snapshot is taken every 30 minutes. Which two sta…