• Home
uCertify Logo
  • 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Login or Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Cart 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

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

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

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

Prepare for the Oracle 1Z0-062 exam 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 text-book, course, or training. The Oracle 1Z0-062 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
  • 60+ Video tutorials
  • 01:05+ Hours
Video Lessons
  • 37+ Videos
  • 14:02+ Hours
Here's what you will learn
Download Course Outline
Lesson 1: Introducing Oracle Database 12c Components and Architecture
  • Oracle Database Fundamentals
  • Oracle Database 12c Architecture
  • Oracle Data Integrator Repositories
  • Summary
  • Exam Essentials
Lesson 2: Creating and Operating Oracle Database 12c
  • 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
Lesson 3: Understanding Storage and Space Management
  • Understanding the Physical and Logical Storage
  • Managing Tablespaces
  • Managing Data Files
  • Managing Space
  • Summary
  • Exam Essentials
Lesson 4: Managing Data Concurrency and Undo
  • Managing Data Changes Using DML
  • Managing Data Concurrency
  • Summary
  • Exam Essentials
Lesson 5: Understanding Oracle Network Architecture
  • 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
Lesson 6: Implementing Security and Auditing
  • Creating and Managing User Accounts
  • Granting and Revoking Privileges
  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary
  • Exam Essentials
Lesson 7: Maintaining the Database and Managing Performance
  • Proactive Database Maintenance
  • Managing Performance
  • Summary
  • Exam Essentials
Lesson 8: Using Backup and Recovery
  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Understanding Types of Database Failures
  • Performing Recovery Operations
  • Summary
  • Exam Essentials
Lesson 9: Controlling Resources and Jobs
  • Resource Management with the Resource Manager
  • Task Automation with Oracle Scheduler
  • Summary
  • Exam Essentials
Lesson 10: Upgrading to Oracle Database 12c
  • Determining the Database Upgrade Method
  • Preparing for a Database Upgrade
  • Upgrading the Database
  • Summary
  • Exam Essentials
Lesson 11: Using Grid Infrastructure and Data Movement Tools
  • Tools for Moving Data
  • Migrating Data Using Data Pump
  • Loading Data with SQL*Loader
  • Populating External Tables
  • Introducing Grid Infrastructure
  • Summary
  • Exam Essentials
Lesson 12: Introduction to DBaaS
  • DBaaS Instance and Database Instance
  • Generating a Secure Shell (SSH) Public/Private Key Pair
  • Navigating with My Services Dashboard
  • User Authentication and Roles
  • Summary
Lesson 13: Video Tutorials
  • 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)

Introducing Oracle Database 12c Components and Architecture

  • 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 and Operating Oracle Database 12c

  • Creating a New Pluggable Database
  • Viewing the User Details
  • Creating a New User in EM Database Express
  • Creating a Group in EM Database Express
  • Dropping a User Using EM Database Express
  • Modifying the Current Database Parameters
  • Managing Initialization-Parameter Files
  • Monitoring the Database Alert Log

Understanding Storage and Space Management

  • Creating a Tablespace
  • Resizing Data Files
  • Creating a Table Using Compression

Managing Data Concurrency and Undo

  • Using UNDO TABLESPACE
  • Using UNDO_RETENTION
  • Updating a Table

Understanding Oracle Network Architecture

  • 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

Implementing Security and Auditing

  • 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

Maintaining the Database and Managing Performance

  • Disabling the Automatic Space Advisor
  • Enabling the Automatic Space Advisor
  • Viewing Automatic Memory Management Components

Using Backup and Recovery

  • Adding New Members in a Database
  • Exporting the Table of a Database
  • Creating Database Repository
  • Importing a Table in Database

Controlling Resources and Jobs

  • Granting the System Privilege
  • Revoking the System Privilege
  • Creating a Scheduler Job

Using Grid Infrastructure and Data Movement Tools

  • 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 , click here.
What are the career opportunities after passing this exam?
  • SQL Developer
  • Oracle Programmer
  • Server Administrator
  • Database Administrator
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept