Scroll to top button

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

Gain hands-on expertise in Oracle Database 12c exam certification exam with the All-in-One 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.

Here's what you will get

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.

Glossary of terms
Test prep
Pre-assessment Questions
Full Length Tests
Exam FAQs
Where do I take the exam? Pearson VUE
What is the format of the exam? The exam consists scenario-based multiple choice questions.
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 MHE-Oracle-12c, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • IT Specialist
  • Oracle Programmer
  • Database Developer
  • Database Administrator

Here's what you will learn

  • Plan for an Oracle Database Software Installation
  • Install the Oracle Database Software
  • Two-Minute Drill
  • 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
  • Configure Storage for Oracle Automatic Storage Management
  • Install Oracle Grid Infrastructure for a Stand-Alone Server
  • Two-Minute Drill
  • Use Oracle Restart to Manage Components
  • Two-Minute Drill
  • 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
  • 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
  • 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
  • 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
  • Describe the Group Functions
  • Group Data Using the GROUP BY Clause
  • Include or Exclude Grouped Rows Using the HAVING Clause
  • Two-Minute Drill
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Configure the Database Resource Manager
  • Access and Create Resource Plans
  • Monitor the Resource Manager
  • Two-Minute Drill
  • 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
  • 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
  • Backup Theory and Basic Syntax
  • Some Advanced RMAN Capabilities
  • Two-Minute Drill
  • Perform Complete and Incomplete Recovery
  • Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
  • Two-Minute Drill
  • Describe the Automatic Diagnostic Workflow
  • Handle Block Corruption
  • Two-Minute Drill
  • 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
  • Describe and Use Transportable Tablespaces and Databases
  • Duplicate a Database
  • Two-Minute Drill
  • Create RMAN-Encrypted Backups
  • Configure and Use Oracle Secure Backup
  • Monitor and Tune RMAN Performance
  • Two-Minute Drill
  • Describe Upgrade Methods
  • Describe Data Migration Methods
  • Describe the Upgrade Process
  • Migrate Data by Using Oracle Data Pump
  • Two-Minute Drill
  • 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
  • Describe the Multitenant Container Database Architecture
  • Explain Pluggable Database Provisioning
  • Two-Minute Drill
  • 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
  • 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
Banner2-OP Banner2-OP
[ORACLE PRESS] All-in-One Course for the OCA/OCP Oracle Database 12c Exams 1Z0-061, 1Z0-062, & 1Z0-063
ISBN : 9781616917296
Rating :