Oracle

Oracle Database 12c: Installation and Administration

(WGU-1Z0-062) / ISBN : 978-1-61691-817-0

Lessons

Lab (Add-on)

TestPrep

317 Reviews

Get A Free Trial

This course includes:

Free pre-assessment and first 2 lessons

13+ Interactive Lessons | 149+ Exercises

37+ Videos | 14:02+ Hours

Accessible on mobile and tablet too

Certificate of completion

$47.00

Buy Now

Are you an instructor?

Access detailed information about the course content, learning objectives, activities, and assessments before adding it to your curriculum.

Skills You’ll Get

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role. Oracle Database 12c: Installation and Administration exam is designed to certify the competency of Database professionals to manage, develop, or implement enterprise-wide databases, middleware, or applications.

Interactive Lessons

13+ Interactive Lessons | 149+ Exercises | 99+ Quizzes | 259+ Flashcards | 58+ Glossary of terms

Gamified TestPrep

52+ Pre Assessment Questions | 5+ Full Length Tests | 70+ Post Assessment Questions | 360+ Practice Test Questions

Hands-On Labs

61+ LiveLab | 61+ Video tutorials | 00+ Minutes

Video Lessons

37+ Videos | 14:02+ Hours

Download Course Outline

Introducing Oracle Database 12c Components and Architecture

Oracle Database Fundamentals
Oracle Database 12c Architecture
Oracle Data Integrator Repositories
Summary
Exam Essentials

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

Understanding Storage and Space Management

Understanding the Physical and Logical Storage
Managing Tablespaces
Managing Data Files
Managing Space
Summary
Exam Essentials

Managing Data Concurrency and Undo

Managing Data Changes Using DML
Managing Data Concurrency
Summary
Exam Essentials

Implementing Security and Auditing

Creating and Managing User Accounts
Granting and Revoking Privileges
Controlling Resource Usage by Users
Auditing Database Activity
Summary
Exam Essentials

Maintaining the Database and Managing Performance

Proactive Database Maintenance
Managing Performance
Summary
Exam Essentials

Using Backup and Recovery

Understanding and Configuring Recovery Components
Performing Backups
Understanding Types of Database Failures
Performing Recovery Operations
Summary
Exam Essentials

Controlling Resources and Jobs

Resource Management with the Resource Manager
Task Automation with Oracle Scheduler
Summary
Exam Essentials

Upgrading to Oracle Database 12c

Determining the Database Upgrade Method
Preparing for a Database Upgrade
Upgrading the Database
Summary
Exam Essentials

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

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

Introduction to DBAAS

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 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

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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

USD 245

Pricing and taxes may vary from country to country. Click here for more information on exam pricing.

The 1Z0-062 exam is administered by Pearson VUE at the testing centers worldwide. Click here to find a testing center near you.

The exam consists scenario-based multiple choice questions.

While there are no official prerequisites to take the Oracle Database 12c: Installation and Administration certification, both Oracle and uCertify strongly recommend that the candidates have a good understanding of the following:

Oracle Database 12c: Admin, Install and Upgrade Accelerated, or
Oracle Database 12c: Install and Upgrade Workshop, and
Oracle Database 12c: Administration Workshop

The exam contains 95 questions.

150 minutes

67%

Click here for more information.

Retake Policy for Oracle 1Z0-062 exam is:

Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
Candidates may retake an online non-proctored exam at any time.
Candidates may not retake a passed exam at any time.
Candidates may not retake a beta exam at any time.

Oracle certifications have no expiration. The certification holder is certified for life unless Oracle changes its policy. Click here for more information.

Know more about the 1Z0-062