1Z0-062.AE1
Oracle DB 12c: Installation & Administration (1Z0-062)
- Practice in 61 Hands-On Labs — nothing to install
- 13 Interactive Lessons and 86 topics mapped to the official exam objectives
- 269 Practice Test Questions and 2 Full Length Tests
Intermediate Self-paced · 1 year access
61 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
13Interactive Lessons
86Topics
61LiveLab
269Practice Test Questions
19Videos
88Flashcards
88Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
13 Interactive Lessons · 86 topics01 Introducing Oracle Database 12c Components and Architecture 5 topics · 9 LiveLab +
- Oracle Database Fundamentals
- Oracle Database 12c Architecture
- Oracle Data Integrator Repositories
- Summary
- Exam Essentials
9 LiveLab in this lesson — see the labs panel →
02 Creating and Operating Oracle Database 12c 8 topics · 8 LiveLab +
- 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
8 LiveLab in this lesson — see the labs panel →
03 Understanding Storage and Space Management 6 topics · 3 LiveLab +
- Understanding the Physical and Logical Storage
- Managing Tablespaces
- Managing Data Files
- Managing Space
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
04 Managing Data Concurrency and Undo 4 topics · 3 LiveLab +
- Managing Data Changes Using DML
- Managing Data Concurrency
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
05 Understanding Oracle Network Architecture 9 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
06 Implementing Security and Auditing 6 topics · 18 LiveLab +
- Creating and Managing User Accounts
- Granting and Revoking Privileges
- Controlling Resource Usage by Users
- Auditing Database Activity
- Summary
- Exam Essentials
18 LiveLab in this lesson — see the labs panel →
07 Maintaining the Database and Managing Performance 4 topics · 3 LiveLab +
- Proactive Database Maintenance
- Managing Performance
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
08 Using Backup and Recovery 6 topics · 4 LiveLab +
- Understanding and Configuring Recovery Components
- Performing Backups
- Understanding Types of Database Failures
- Performing Recovery Operations
- Summary
- Exam Essentials
4 LiveLab in this lesson — see the labs panel →
09 Controlling Resources and Jobs 4 topics · 3 LiveLab +
- Resource Management with the Resource Manager
- Task Automation with Oracle Scheduler
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
10 Upgrading to Oracle Database 12c 5 topics +
- Determining the Database Upgrade Method
- Preparing for a Database Upgrade
- Upgrading the Database
- Summary
- Exam Essentials
11 Using Grid Infrastructure and Data Movement Tools 7 topics · 4 LiveLab +
- Tools for Moving Data
- Migrating Data Using Data Pump
- Loading Data with SQL*Loader
- Populating External Tables
- Introducing Grid Infrastructure
- Summary
- Exam Essentials
4 LiveLab in this lesson — see the labs panel →
12 Introduction to DBaaS 5 topics +
- DBaaS Instance and Database Instance
- Generating a Secure Shell (SSH) Public/Private Key Pair
- Navigating with My Services Dashboard
- User Authentication and Roles
- Summary
13 Video Tutorials 17 topics +
- 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 Labs Our edge
61 LiveLabs- 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
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
![1Z0-071.AO1: [ORACLE PRESS] Oracle Database SQL_Image](http://d3hu3i8dxloald.cloudfront.net/images/new/MHE-1Z0-071_pro.png?202608009V)
Prepare for Oracle DB 12c: Installation & Administration (1Z0-062)
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 61 LiveLab included
- Certificate of completion
No credit card required