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

  1. Question 106: The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR. You have the CREATE DATABASE LINK and CREATE SESSION privileges on bot…
  2. Question 107: You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
  3. Question 108: You ran this command on a source database:
    gt; expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept On the target database, you run this com…
  4. Question 110: Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 - MEMORY_TARGET=0 - SGA_TARGET=0 - PGA_AGGREGATE_TARGET=500m - Which three initia…
  5. Question 111: A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the d…
  6. Question 112: Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)
  7. Question 113: Which three are activities performed by SMON? (Choose three.)
  8. Question 114: You install Oracle Grid Infrastructure for a standalone server. Which two components are automatically included in the Oracle Restart configuration? (Choose tw…
  9. Question 115: Which two are true about the SMON background process? (Choose two.)
  10. Question 116: Which two are true about database table rows? (Choose two.)