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

  1. Question 164: Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)
  2. Question 165: To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = /dev/flash_device_1 , /dev/flash_device_2 DB_FLASH_CACH…
  3. Question 166: Examine the command: SQL> CREATE TABLESPACE test1 - DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M AUTOEXTEND ON UNIFORM; Which statement is true?
  4. Question 167: What must you use to read data from a table in your database and write it to an external table?
  5. Question 168: Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started…
  6. Question 169: Which three statements are true about user account administration? (Choose three.)
  7. Question 170: You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command: RMAN> DELETE OBSOLETE;…
  8. Question 171: Which three statements are true about checkpointing? (Choose three.)
  9. Question 172: The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction. Which two types of lock exi…
  10. Question 173: Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)