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

  1. Question 140: You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY…
  2. Question 141: Which three are true about the default database buffer cache? (Choose three.)
  3. Question 142: Your database instance has Automatic Memory Management enabled and supports shared server connections. Examine the following: 1. Parallel execution messages an…
  4. Question 143: Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs t…
  5. Question 144: Which statement is true about profiles?
  6. Question 145: You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform. Which…
  7. Question 146: You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log file…
  8. Question 147: You create a locally managed tablespace ORDERS_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace usi…
  9. Question 148: Examine the command: SQL> CONNECT hr/hr@orcl - Which two configurations allow this command to execute successfully? (Choose two.)
  10. Question 149: Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)