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

  1. Question 77: The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON option that refer…
  2. Question 79: One of your databases supports an OLTP workload. The default UNDO tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. UNDO_RETENTION is 12 minutes User…
  3. Question 80: One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which com…
  4. Question 81: Which three statements are true PFILEs, SPFILEs or both? (Choose three.)
  5. Question 82: You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the…
  6. Question 83: Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
  7. Question 85: In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
    gt; sqlldr hr/hr table=employees Which two statements are true about this…
  8. Question 86: You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct-path INSERT and conventional DML. The tab…
  9. Question 87: Your production database PROD uses file system storage. You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic…
  10. Question 88: Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)