1Z0-061-062-063 : [ORACLE PRESS] All-in-One Course for the OCA/OCP Oracle Database 12c Exams 1Z0-061, 1Z0-062, & 1Z0-063

[ORACLE PRESS] All-in-One Course for the OCA/OCP Oracle...
ISBN : 978-1-61691-729-6

Gain hands-on expertise in Oracle Database 12c exam certification exam by All-in-One Course for the OCA/OCP Oracle Database 12c exams course. Oracle Database 12c exam is designed to certify the competency of professionals in enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.



uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keep the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keep learners engaged and make learning fun.

Here's What You Get

Exercises Flashcards Quizzes Glossary

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts. Glossary defines the key terms.

Exercise Questions
Glossary of terms

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
Full Length Tests


Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Exam Information

The Oracle Certified Associate (OCA) credential is typically the first step toward achieving the flagship Oracle Certified Professional certification. The OCA credential ensures that the individual is equipped with fundamental skills, providing a strong foundation for supporting Oracle products. An OCA credential is available for several of today's most in-demand technology job roles.

The Oracle Certified Professional (OCP) credential is the benchmark of professional skill and technical expertise required to manage, develop, or implement enterprise-wide databases, middleware, or applications. Increasingly, IT managers use the OCP credential to evaluate the qualifications of employees and job candidates.

Prepare for the following certification

Career Prospects
  • Database Administrator
  • Database Developer
  • IT Specialist
  • Oracle Programmer

Table of Content

Here's What you will Learn

Lesson 1: Installing Oracle Database Software

  • Plan for an Oracle Database Software Installation
  • Install the Oracle Database Software
  • Two-Minute Drill

Lesson 2: Creating an Oracle Database Using DBCA

  • Create a Database by Using the Database Configuration Assistant
  • Generate Database Creation Scripts by Using DBCA
  • Manage Database Design Templates by Using DBCA
  • Configure Database Options by Using DBCA
  • Two-Minute Drill

Lesson 3: Installing Oracle Grid Infrastructure for a Stand-Alone Server

  • Configure Storage for Oracle Automatic Storage Management
  • Install Oracle Grid Infrastructure for a Stand-Alone Server
  • Two-Minute Drill

Lesson 4: Using Oracle Restart

  • Use Oracle Restart to Manage Components
  • Two-Minute Drill

Lesson 5: DDL and Schema Objects

  • Use the Client Tools
  • Categorize the Main Database Objects
  • List the Data Types that Are Available for Columns
  • Create a Simple Table
  • Create and Use Temporary Tables
  • Indexes
  • Constraints
  • Views
  • Synonyms
  • Sequences
  • Two-Minute Drill

Lesson 6: DML and Concurrency

  • Describe Each Data Manipulation Language Statement
  • Control Transactions
  • Explain DML and Undo Data Generation
  • Monitor and Administer Undo Data
  • Describe the Difference Between Undo Data and Redo Data
  • Configure Undo Retention
  • Describe the Locking Mechanism and Data Concurrency Management
  • Monitor and Resolve Locking Conflicts
  • Two-Minute Drill

Lesson 7: Retrieving, Restricting, and Sorting Data Using SQL

  • Explain the Capabilities of SQL SELECT Statements
  • Data Normalization
  • Execute a Basic SELECT Statement
  • Limit the Rows Retrieved by a Query
  • Sort the Rows Retrieved by a Query
  • Ampersand Substitution
  • Two-Minute Drill

Lesson 8: Single-Row and Conversion Functions

  • Describe and Use Character, Number, and Date Functions in SQL
  • Describe Various Types of Conversion Functions Available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
  • Apply Conditional Expressions in a SELECT Statement
  • Two-Minute Drill

Lesson 9: Group Functions

  • Describe the Group Functions
  • Group Data Using the GROUP BY Clause
  • Include or Exclude Grouped Rows Using the HAVING Clause
  • Two-Minute Drill

Lesson 10: SQL Joins

  • Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
  • Join a Table to Itself Using a Self-Join
  • View Data That Does Not Meet a Join Condition by Using Outer Joins
  • Generate a Cartesian Product of Two or More Tables
  • Two-Minute Drill

Lesson 11: Subqueries and Set Operators

  • Define Subqueries
  • Describe the Types of Problems that the Subqueries Can Solve
  • Describe the Types of Subqueries
  • Write Single-Row and Multiple-Row Subqueries
  • Describe the Set Operators
  • Use a Set Operator to Combine Multiple Queries into a Single Query
  • Control the Order of Rows Returned
  • Two-Minute Drill

Lesson 12: Architectural Overview of Oracle Database 12c

  • List the Architectural Components of an Oracle Database
  • Explain the Memory Structures
  • Describe the Background Processes
  • Explain the Relationship Between Logical and Physical Storage Structures
  • Two-Minute Drill

Lesson 13: Instance Management

  • Use Database Management Tools
  • Understand Initialization Parameter Files
  • Start Up and Shut Down an Oracle Database Instance
  • View the Alert Log and Access Dynamic Performance Views
  • Two-Minute Drill

Lesson 14: Oracle Networking

  • Configure Oracle Net Services
  • Use Tools for Configuring and Managing the Oracle Network
  • Configure Client-Side Network
  • Understand Database Resident Connection Pooling
  • Configure Communication Between Databases
  • Two-Minute Drill

Lesson 15: Oracle Storage

  • Describe the Storage of Table Row Data in Blocks
  • Create and Manage Tablespaces
  • Explain How Oracle Database Server Automatically Manages Space
  • Save Space by Using Compression
  • Proactively Monitor and Manage Tablespace Space Usage
  • Use the Segment Advisor
  • Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
  • Manage Resumable Space Allocation
  • Two-Minute Drill

Lesson 16: Oracle Security

  • Create and Manage Database User Accounts
  • Grant and Revoke Privileges
  • Create and Manage Roles
  • Create and Manage Profiles
  • Explain DBA Responsibilities for Security and Auditing
  • Enable Standard Database Auditing and Unified Auditing
  • Two-Minute Drill

Lesson 17: Moving and Re-organizing Data

  • Describe Ways to Move Data
  • Create and Use Directory Objects
  • Use SQL*Loader to Load Data from a Non-Oracle Database
  • Use External Tables to Move Data via Platform-Independent Files
  • Explain the General Architecture of Oracle Data Pump
  • Use Data Pump Export and Import to Move Data Between Oracle Databases
  • Use Data Pump in a Multitenant Environment
  • Use SQL*Loader in a Multitenant Environment
  • Two-Minute Drill

Lesson 18: The AWR and the Alert System

  • Manage the Automatic Workload Repository
  • Use the Automatic Database Diagnostic Monitor
  • Describe and Use the Advisory Framework
  • Set Alert Thresholds
  • Use Automated Tasks
  • Two-Minute Drill

Lesson 19: Performance Tuning

  • Use Enterprise Manager to Monitor Performance
  • Use Automatic Memory Management
  • Use the Memory Advisor to Size Memory Buffers
  • Manage Optimizer Statistics
  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to Tune Workload
  • Two-Minute Drill

Lesson 20: The Resource Manager

  • Configure the Database Resource Manager
  • Access and Create Resource Plans
  • Monitor the Resource Manager
  • Two-Minute Drill

Lesson 21: The Scheduler

  • Use Oracle Scheduler to Simplify Management Tasks
  • Use Job Chains to Perform a Series of Related Tasks
  • Use Scheduler Jobs on Remote Systems
  • Use Advanced Scheduler Features to Prioritize Jobs
  • Two-Minute Drill

Lesson 22: Configuring the Database for Backup and Recovery

  • Possible Failures and Their Resolution
  • Checkpoints and the Redo Log
  • Backup and Recovery: Configuration
  • Configure the Fast Recovery Area
  • Configure ARCHIVELOG Mode
  • Two-Minute Drill

Lesson 23: Back Up with RMAN

  • Backup Theory and Basic Syntax
  • Some Advanced RMAN Capabilities
  • Two-Minute Drill

Lesson 24: Restore and Recover with RMAN

  • Perform Complete and Incomplete Recovery
  • Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
  • Two-Minute Drill

Lesson 25: Diagnosing Failures

  • Describe the Automatic Diagnostic Workflow
  • Handle Block Corruption
  • Two-Minute Drill

Lesson 26: Flashback

  • Describe the Flashback Technologies
  • Use Flashback to Query Data
  • Perform Flashback Table Drop Operations
  • Perform Table Recovery from Backups
  • Describe and Use Flashback Data Archive
  • Perform Flashback Database
  • Two-Minute Drill

Lesson 27: Duplicating a Database

  • Describe and Use Transportable Tablespaces and Databases
  • Duplicate a Database
  • Two-Minute Drill

Lesson 28: Encrypting, Securing, Monitoring, and Tuning RMAN Backups

  • Create RMAN-Encrypted Backups
  • Configure and Use Oracle Secure Backup
  • Monitor and Tune RMAN Performance
  • Two-Minute Drill

Lesson 29: Upgrading Oracle Database Software and Migrating Data

  • Describe Upgrade Methods
  • Describe Data Migration Methods
  • Describe the Upgrade Process
  • Migrate Data by Using Oracle Data Pump
  • Two-Minute Drill

Lesson 30: Upgrading an Oracle Database

  • Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
  • Use the Pre-Upgrade Information Tool Before Performing an Upgrade
  • Prepare the New Oracle Home Prior to Performing an Upgrade
  • Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
  • Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
  • Migrate to Unified Auditing
  • Perform Postupgrade Tasks
  • Two-Minute Drill

Lesson 31: Multitenant Container and Pluggable Database Architecture

  • Describe the Multitenant Container Database Architecture
  • Explain Pluggable Database Provisioning
  • Two-Minute Drill

Lesson 32: Creating and Managing Multitenant Container and Pluggable Databases

  • Create a Container Database
  • Create Pluggable Containers
  • Migrate a Pre-12.1 Non-CDB Database to CDB
  • Establish Connections to CDBs and PDBs
  • Start Up and Shut Down a CDB and Open and Close PDBs
  • Evaluate the Impact of Parameter Value Changes
  • Two-Minute Drill

Lesson 33: Managing Storage, Security, Availability, and Performance in a CDB and PDBs

  • Space Management in a Multitenant Environment
  • Manage Common and Local Users, Roles, and Privileges
  • Multitenant Backup and Recovery
  • Duplicate PDBs Using RMAN
  • Mulitenant Performance Monitoring and Tuning
  • Manage Allocation of Resources Between PDBs and Within a PDB
  • Perform Database Replay
  • Two-Minute Drill

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved