Scroll to top button

Oracle Database 12c: Installation and Administration

ISBN : 9781616913472

Start your prep for the Oracle Database 12c 1Z0-062 certification exam with Oracle Database 12c: Installation and Administration course. The study guide covers the objectives of 1Z0-062 exam and provides skills on the topics such as DBAAS; Oracle Database 12c components and architecture; creation and operation of Oracle Database 12c; storage and space management; network architecture; backup and recovery; and many more. The cert guide is designed for database administrators, support engineers, technical administrators, and data warehouse administrators who have working knowledge of SQL and PL/SQL packages, and basic knowledge of Linux operating system.

The Oracle Certified Associate (OCA) credential is the first step towards achieving the Oracle Certified Professional (OCP) certification. OCA certification proves that you have the fundamental knowledge and skills to support an Oracle Database 12c. The OCA Database 1Z0-062 exam focuses on the topics like Database management and performance measurement; controlling resources and jobs; grid infrastructure and data movement; and many more. This exam has been validated against Oracle Database

Glossary of terms
Pre Assessment Questions
Post Assessment Questions
LiveLab (Add-on Component)
Video tutorials

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam related FAQs
What is the exam registration fee? USD 245
Where do I take the exam? Pearson VUE
What is the format of the exam? The exam consists scenario-based multiple choice questions.
How many questions are asked in the exam? The exam contains 67 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 64%
What is the exam's retake policy?

Here are the retake policies:

  • Candidates may not retake a beta exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates are only allowed 4 attempts to pass an exam in a 12-month period.
  • Candidates must resubmit a failed Master Assignment within 30 days of receiving the notification of failing.
  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
What is the validity of the certification? Oracle certifications have no expiration unless Oracle changes its policy.
Where can I find more information about this exam? To know more about the 1Z0-062, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • DBA
  • SQL Developer
  • Oracle Programmer
  • Server Administrator
  • Database Administrator
  • Oracle Database Fundamentals
  • Oracle Database 12c Architecture
  • Oracle Data Integrator Repositories
  • Summary
  • Exam Essentials
  • Oracle Database 12c Software Installation
  • Using DBCA to Create an Oracle 12c Database
  • Working with Oracle Database Metadata
  • Managing Initialization-Parameter Files
  • Starting Up and Shutting Down an Oracle Instance
  • Monitoring the Database Alert Log
  • Summary
  • Exam Essentials
  • Understanding the Physical and Logical Storage
  • Managing Tablespaces
  • Managing Data Files
  • Managing Space
  • Summary
  • Exam Essentials
  • Managing Data Changes Using DML
  • Managing Data Concurrency
  • Summary
  • Exam Essentials
  • Introducing Network Configurations
  • An Overview of Oracle Net Features
  • Configuring Oracle Net on the Server
  • Configuring Oracle Net for the Client
  • An Overview of Oracle Shared Server
  • Understanding Database Resident Connection Pooling
  • Communicating Between Databases
  • Summary
  • Exam Essentials
  • Creating and Managing User Accounts
  • Granting and Revoking Privileges
  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary
  • Exam Essentials
  • Proactive Database Maintenance
  • Managing Performance
  • Summary
  • Exam Essentials
  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Understanding Types of Database Failures
  • Performing Recovery Operations
  • Summary
  • Exam Essentials
  • Resource Management with the Resource Manager
  • Task Automation with Oracle Scheduler
  • Summary
  • Exam Essentials
  • Determining the Database Upgrade Method
  • Preparing for a Database Upgrade
  • Upgrading the Database
  • Summary
  • Exam Essentials
  • Tools for Moving Data
  • Migrating Data Using Data Pump
  • Loading Data with SQL*Loader
  • Populating External Tables
  • Introducing Grid Infrastructure
  • Summary
  • Exam Essentials
  • Introduction
  • Database Concepts And Tools
  • DML Atomicity
  • DML Statements
  • Data Concurrency
  • Backup
  • Installation
  • Memory Structure
  • Tables
  • Indexes
  • Constraints And Triggers
  • Implementing Security
  • Storage Structures
  • Internal Memory Structures
  • Background Processes
  • Starting And Stopping Database
  • Critical Storage Files

Hands on Activities (LiveLab)

Customer Testimonials

Emmanuel Adesotu
The uCertify Oracle DBA course is very much interactive and contains a very detailed lecture on Oracle architecture, absolutely for a beginner, The lecturer did justice to the course and I recommend for everyone that wishes to learn the internal operation of Oracle database.