2 minute read
You enable In Database Archiving by doing which of the following?
Basics of Multitenant Container Database - Identify the benefits of the multitenant (CDB) container database - Explain root and multitenant architecture Managing CDBs and PDBs - Establish connection to a CDB/PDB - Start up and shut down a CDB/PDB - Change instance parameters for a CDB/PDB Backup, Recovery and Flashback for a - Perform backup of CDB and PDB CDB/PDB - Perform recovery of CDB and PDB - Perform Flashback for a CDB In-Database Archiving and Valid-Time - Differentiate between ILM and Valid-Time Temporal Temporal - Set and use Valid Time Temporal - Use In-Database archiving Privileges - Use administrative privileges - Create, enable and use privilege analysis RMAN and Flashback Data Archive - Use RMAN enhancements - Implement the new features in Flashback Data Archive SQL Tuning - Use Adaptive Execution Plans - Use enhanced features of statistics gathering - Use Adaptive SQL Plan Management Resource Manager and Other Performance - Use Resource Manager for a CDB and PDB Enhancements - Explain Multi-process Multi-threaded Oracle architecture - Use Flash Cache ADR and Network Enhancements - Explain ADR enhancements Partitioning Enhancements - Explain Partitioning enhancements - Explain Index enhancements for partitioned tables
Key DBA Skills
Advertisement
Core Administration - Explain the fundamentals of DB architecture - Install and configure a database - Configure server and client network for a database - Monitor database alerts - Perform daily administration tasks - Apply and review patches - Back up and recover the database - Troubleshoot network and database issues - Detect and repair data failures with Data Recovery Advisor - Implement Flashback Technology - Load and Unload Data
Storage - Miscellaneous Relocate SYSAUX occupants Create a default permanent tablespace Use the Redo Logfile Size Advisor Use Secure File LOBs Use Direct NFS - Manage database structures - Administer ASM - Manage ASM disks and diskgroups - Manage ASM instance - Manage VLDB - Implement Space Management
Oracle 1Z0-060 Certification Sample Questions and Answers
To make you familiar with Upgrade to Oracle Database 12c (1Z0-060) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for Oracle OCP 1Z0-060 Certification to test your understanding of the Oracle 1Z0-060 process with the real Oracle certification exam environment.
10. In the Temporal Validity feature, you can do which of the following?
a) Control visibility for all DML and DDL statements b) Control visibility for only DML statements c) Control visibility for only DDL statements d) Control visibility for only queries
02. Which two are true concerning a multitenant container database with three pluggable database?
a) All administration tasks must be done to a specific pluggable database. b) The pluggable databases increase patching time. c) The pluggable databases reduce administration effort. d) The pluggable databases are patched together. e) Pluggable databases are only used for database consolidation.
03. A container data object is a table or view that shows data pertaining to:
a) Only the CDB b) Only a specific PDB container c) One or more PDBs and the CDB as a whole d) Only a group of PDBs
