Exam 1Z0-060 - Upgrade to Oracle Database 12c

Oracle Database, Oracle Corporation's flagship product, is so central to the company's identity that most people refer to the computing world's signature relational database management system (RDBMS) simply as Oracle. The latest version, Oracle Database 12c, was released in 2014. Oracle has been the leading player in the RDBMS game for quite a while now, and while you may occasionally hear opinions to the contrary, that position of preeminence is likely to remain secure in the foreseeable future.

Oracle certification expert Matthew Morris has created a series of practice tests at his site, Oracle Certification Prep. These free practice questions are a sampling of what you'll find there. After you try these questions, visit Oracle Certification Prep for (paid) access to a full 1Z0-060: Upgrade to Oracle Database 12c practice test.

Ready to rumble? Simply scroll down the page to begin your quiz. Or check out our other free Oracle quizzes.

Note: Your browser must permit multiple dialog boxes per page in order to complete this quiz.

Question 1:

Which of the following statements about the Oracle Multitenant Architecture is true?

A. Each of the PDBs in the CDB can use a different character set.
B. There is one active undo tablespace for each PDB.
C. There is one SYSTEM tablespace for a CDB.
D. There is a single redo log and a single control file for an entire CDB.
E. Every container database has one root, one seed PDB, and one or more PDBs.

‍

Question 2:

Which of the following statements is true about the DROP PLUGGABLE DATABASE statement?

A. The PDB must be open in order for the DROP command to function correctly.
B. The control file of the CDB will be modified to eliminate all references to the dropped PDB.
C. Archived redo log files and backups associated with the PDB are removed.
D. The current user must have the DBA role in the PDB in order to drop a PDB.
E. The PDB's data files will be deleted.

‍

Question 3:

Which of the following backup types had multiple section backup capability added in Oracle 12c?

A. Image copy backups
B. Tablespace backups
C. Backups to Tape
D. Datafile Backups
E. Backup Sets

‍

Question 4:

Which of the following statements about the ENABLE_DDL_LOGGING initialization parameter is correct?

A. A TRUNCATE TABLE operation would not be be logged.
B. DDL information that is logged can be accessed via the DBA_DDL_LOGGING view.
C. A subset of data definition language statements will be logged when they are executed in the database.
D. The DDL information will be logged directly to the standard database alert log text and XML files.
E. When the parameter is set to FALSE, only DDL statements that generate exceptions are logged.

‍

Question 5:

Which of the following types of failures can the Data Recovery Advisor diagnose?

A. Archived redo log files that are not accessible by the database.
B. Block checksum failures in data files.
C. Data corruptions in archived redo logs.
D. Failures due to a missing or corrupt server parameter file.
E. Invalid block header field values in RMAN backup sets.

‍