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

  1. Question 117: Which four are true about the SHUTDOWN TRANSACTIONAL command and its effects in a single instance Oracle database environment with a single active transaction?…
  2. Question 118: Which three statements are true about the SQL Tuning Advisor? (Choose three.)
  3. Question 119: You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: Versio…
  4. Question 120: An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following pa…
  5. Question 121: Which three statements are true about adaptive SQL plan management? (Choose three.)
  6. Question 122: Which two statements are true about variable extent size support for large ASM files? (Choose two.)
  7. Question 123: SALES is a valid TNS entry referring to: Hostname: HOST01 - Port: 1521 - Service_name: SALES_SRV - You issue this command: $ tnsping SALES Which two are true?…
  8. Question 124: You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two a…
  9. Question 125: You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal re…
  10. Question 126: Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)