Oracle DB 12c: Installation & Administration (1Z0-062)

(1Z0-062-2019) / ISBN: 9781644590898
This course includes
Lessons
TestPrep
LiveLab (Add-on)
Mentoring (Add-on)
Share
$200.99
Try This Course
Are you an instructor?
Request a free evaluation copy

Oracle DB 12c: Installation & Administration (1Z0-062)

Become a certified Oracle Database 12c professional with the Oracle DB 12c: Installation & Administration (1Z0-062) course and lab. The lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, or training. The course and lab completely cover the 1Z0-062 exam objectives and provide the skills required for the creation and operation of the Oracle Database 12c. These skills include storage and space management, network architecture, backup, recovery, and more.
Here's what you will get

The Oracle Certified Associate (OCA) certification is the first step towards getting 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 much more. This exam has been validated against Oracle Database 12.1.0.1.0.

Lessons
  • 13+ Lessons
  • 132+ Quizzes
  • 88+ Flashcards
  • 88+ Glossary of terms
TestPrep
  • 70+ Pre Assessment Questions
  • 2+ Full Length Tests
  • 70+ Post Assessment Questions
  • 140+ Practice Test Questions
LiveLab (Add-on)
  • 61+ LiveLab
  • 61+ Video tutorials
  • 01:07+ Hours
Video Lessons
  • 37+ Videos
  • 14:02+ Hours
Here's what you will learn
Download Course Outline
  • 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 (Live Labs)

  • Displaying the Connection Name
  • Displaying Information About the Active Services in the Database
  • Unlocking the Pluggable Database
  • Altering the Session of the Database Container and the Pluggable Database
  • Unlocking and Connecting to the User Account
  • Understanding SGA
  • Creating a Cluster
  • Creating a Cluster Index
  • Removing a Cluster
  • Creating a New Pluggable Database
  • Viewing the User Details
  • Creating a New User Using SQL Plus
  • Creating a Group Using SQL Plus
  • Dropping a User Using SQL Plus
  • Modifying the Current Database Parameters
  • Managing Initialization-Parameter Files
  • Monitoring the Database Alert Log
  • Creating a Tablespace
  • Resizing Data Files
  • Creating a Table Using Compression
  • Using UNDO TABLESPACE
  • Using UNDO_RETENTION
  • Updating a Table
  • Creating a Local Connection using the SQL Developer
  • Creating a Listener
  • Configuring the Local Naming Method
  • Using the V$SESSION View
  • Configuring DBMS_CONNECTION_POOL
  • Creating Database Links
  • Creating a Database User and Granting Privileges to a User
  • Creating and Granting Roles to a User
  • Revoking Privileges and Dropping a Role
  • Creating a Table using a Primary Key
  • Working with DML Triggers
  • Working with DDL Triggers
  • Working with System Event Triggers
  • Using the Instead-of Triggers
  • Using Constraints in the Table
  • Creating a View
  • Updating a View
  • Dropping a View
  • Creating a Procedure in SQL Plus
  • Dropping a Procedure in SQL Plus
  • Creating and Executing a Function in SQL Plus
  • Dropping a Function in SQL Plus
  • Creating a Profile
  • Enabling Privilege Auditing in SQL Plus
  • Disabling the Automatic Space Advisor
  • Enabling the Automatic Space Advisor
  • Viewing Automatic Memory Management Components
  • Adding New Members in a Database
  • Exporting the Table of a Database
  • Creating Database Repository
  • Importing a Table in Database
  • Granting the System Privilege
  • Revoking the System Privilege
  • Creating a Scheduler Job
  • Exporting a Table Using SQL Plus
  • Setting Up the Dump Location
  • Loading External Tables Using Data Pump
  • Managing Tablespace Storage
Exam 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, click here.
What are the career opportunities after passing this exam?
  • SQL Developer
  • Oracle Programmer
  • Server Administrator
  • Database Administrator
×