Oracle Database 12c: Advanced Administration Free Practice Exam Questions

177 real Oracle Database 12c: Advanced Administration exam questions with answers and AI explanations. Oracle certification prep — page 17 of 18.

  1. Question 169: You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database: CONNECT/AS SYSDBA - ALTER SYSTEMSETTHREAD…
  2. Question 170: Examine the commands executed to monitor database operations:
    gt; conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER - SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_O…
  3. Question 171: One of your databases is in ARCHIVELOG mode and take nightly RMAN backups. The USERS and IDX tablespaces are missing due to storage array errors. Which four ac…
  4. Question 172: You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature sh…
  5. Question 173: Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator?
  6. Question 174: Which three are true about Transparent Data Encryption (TDE)? (Choose three.)
  7. Question 175: In which situation can you use Flashback Database?
  8. Question 176: You issue the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN>CONFIGURE CONTROLFILE AUTO…
  9. Question 177: Which three requirements must be met before a tablespace can be transported across different platforms?
  10. Question 178: Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?