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 7 of 18.

  1. Question 63: Which two statements are true about dropping a pluggable database (PDB)?
  2. Question 64: Which two statements describe the relationship between a window, a resource plan, and a job class?
  3. Question 65: You want to move your existing recovery catalog to another database. Examine the steps: 1) Export the catalog data by using the Data Pump Export utility in the…
  4. Question 67: Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPL…
  5. Question 69: On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command: S>sqlldrhr/hr@pdb table=emplo…
  6. Question 70: Identify two scenarios in which the RMAN crosscheck command can be used.
  7. Question 71: A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow. Wha…
  8. Question 72: Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs t…
  9. Question 73: Your database supports an OLTP workload. Examine the output of the query: SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery - Target_mttrestimat…
  10. Question 74: Which three conditions must be met before you create a Virtual Private Catalog (VPC)?