Scroll to top button

Oracle Database 12c: Installation and Administration

ISBN : 9781644590898

Prepare for the Oracle Database 12c 1Z0-062 certification exam with the Oracle Database 12c: Installation and Administration course and lab. The lab simulates real-world, hardware, software and command line interface environments and can be mapped to any text-book, course or training. The course and lab completely cover the 1Z0-062 exam objectives and provide skills required for creation and operation of the Oracle Database 12c. These skills include storage and space management; network architecture, backup, recovery, and more. The course is designed for database administrators, support engineers, and data warehouse administrators who have a working knowledge of SQL and PL/SQL packages, and basic knowledge of the Linux operating system.

The Oracle Certified Associate (OCA) certification is the first step towards achieving the Oracle Certified Professional (OCP) certification. The Oracle OCA certification proves that you have the fundamental knowledge and skills needed to support an Oracle Database 12c. The OCA Database 1Z0-062 exam focuses on 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
Full Length Tests
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? multiple choice
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-2019, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • 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
  • DBaaS Instance and Database Instance
  • Generating a Secure Shell (SSH) Public/Private Key Pair
  • Navigating with My Services Dashboard
  • User Authentication and Roles
  • Summary
  • 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)