Oracle Database 12c: Installation and Administration

Objectives of the Certification Exam

Who is Eligible for this Exam? / Is this Certification Right for You?

Following candidates are eligible for the 1z0-062 Certification Exam:

• Individuals involved in the database
• Engineers
• Technical administrators
• System administrators
• Specialists willing to pass the exam

Requirements for 1z0-062 Certification

[[Recommended]

1. Oracle Database 12c: Administration Workshop
2. Oracle Database Learning Subscription
3. Unlimited Learning Subscription - All Technology

[Required]

1. Oracle Database 12c SQL 1Z0-071

Facts about 1Z0-062 Certification

Here are some of the facts about the 1Z0-062 certification exam:

Benefits of Oracle Certification

Attempting and passing the 1Z0-062 exam has many benefits for applicants. Some of them are:

Certification Syllabus Content

Exploring the Oracle Database Architecture

• List the architectural components of Oracle Database
• Explain the memory structures
• Describe the background processes

Oracle Database Management Tools

• Use database management tools

Oracle Database Instance

• Understand initialization parameter files
• Startup and shutdown an Oracle database instance
• View the alert log and access dynamic performance views

Configuring the Oracle Network Environment

• Configure Oracle Net Services
• Use tools for configuring and managing the Oracle network
• Configure client-side network
• Configure communication between databases

Administering User Security

• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles

Managing Database Storage Structures

• Describe the storage of table row data in blocks
• Create and manage tablespaces

Create and manage tablespaces

• Explain how the Oracle database server automatically manages space
• Save space by using compression
• Use the Segment Advisor
• Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Undo Data

• Explain DML and undo data generation
• Monitor and administer undo data
• Describe the difference between undo data and redo data
• Configure undo retention

Managing Data Concurrency

• Describe the locking mechanism and how Oracle manages data concurrency
• Monitor and resolve locking conflicts

Implementing Oracle Database Auditing

• Enable standard database auditing and unified auditing

Backup and Recovery Concepts

• Identify the importance of checkpoints, redo log files, and archive log files

Backup and Recovery Configuration

• Configure the fast recovery area
• Configure ARCHIVELOG mode

Performing Database Backups

• Create consistent database backups
• Backup your database without shutting it down
• Create incremental backups
• Automate database backups
• Manage backups

Performing Database Recovery

• Determine the need for performing recovery
• Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file

Moving Data

• Describe ways to move data
• Use SQL*Loader to load data from a non-Oracle database
• Use external tables to move data via platform-independent files
• Explain the general architecture of the Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases

Performing Database Maintenance

• Use server-generated alerts

Managing Performance: SQL Tuning

• Use the SQL Tuning advisor

Automating Tasks by Using Oracle Scheduler

• Use Oracle Scheduler to simplify management tasks
• Use job chains to perform a series of related tasks
• Use Scheduler jobs on remote systems
• Use advanced Scheduler features to prioritize jobs

Creating an Oracle Database Using DBCA 

• Generate database creation scripts by using DBCA 
• Manage database design templates by using DBCA

Upgrading Oracle Database Software  

• Describe data migration methods
• Describe the upgrade process

Introduction to DBaaS

• Recognize the difference between a DBaaS Instance and a Database Instance
• Navigate with My Services Dashboard
• User authentication and roles
• Generate a Secure Shell (SSH) Public/Private Key Pair

Career Opportunities

You will get the following job opportunities after the Oracle Database 12c: Installation and Administration certification:

Certification Renewal Policy

Oracle Database Certification is valid for 18 months from the date of receiving the credential. The certificates will become inactive by the end of 18 months. Candidates must recertify for the new edition of the exam to stay up-to-date. Certifications for the Oracle Database include Oracle Certified Associates, Specialists, and Technical names.

Certification Reschedule/Cancellation Policy

If you want to postpone your exam appointment, you must reschedule at least 24 hours before your appointment. If you reschedule or cancel your exam during the 24 hours of your appointed exam time, you will lose the entire exam fee. Oracle will forfeit your complete fee. Please note that you can only reschedule your examination appointment five times a year. You must cancel your current appointment first if you need to reschedule for the sixth time. 

If you decide to cancel your exam appointment, you must cancel at least 24 hours before your exam appointment. The cancellation of the test less than 24 hours before the scheduled test is subject to a forfeit examination fee on the same day. Completion of examination fees for no-shows is due.

How can I Attend the Exam?

You can take the 1z0-062 test at the test center or online. The duration of the exam is 120 minutes. Some of the measures to be taken are as follows: 

In the current epidemic scenario, an online exam is used for all Oracle certification examinations. There are some guidelines to be followed for an online exam.

1. You need to use a webcam. 
2. First, run a system test, schedule an exam, and start the test.

Conclusion

Oracle Database 12c: Installation and Administration provide you with the clear concept of initialization file parameters, tools to configure and manage the Oracle network, configuring communication between databases, explanation of the memory structure, view the alert log and access the dynamic performance view, granting and withdrawing privileges, development, and management of roles and profiles. After you pass this certification exam, you can work as a professional database specialist. Serving as a database administrator would be a promising achievement for your Career. 

ExamPirate provides you with all the necessary study material such as certification information, practice exams, eligibility criteria, and a preparation guide. We help you to excel in any certification exam and get the credential you've always wanted!