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

  1. Question 151: What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
  2. Question 152: You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid…
  3. Question 153: You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the foll…
  4. Question 154: You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: Applications will connect to the databas…
  5. Question 155: Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database. Which two tools or utilities would you use to achieve thi…
  6. Question 157: Which three are true about server processes for dedicated server connections? (Choose three.)
  7. Question 158: Which two statements are true about Oracle network connections? (Choose two.)
  8. Question 161: What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?
  9. Question 162: An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted. Which two types of lock are held by the transac…
  10. Question 163: Which three statements are true about Enterprise Manager Database Express? (Choose three.)