Course in Pre-Launch Mode,Total number of question will be around 120+.

Oracle Database SQL 1Z0-072 Test series  

1Z0-072 practice test

This course contain 3 Practice test for Oracle Certification  exam 1Z0-072 for Oracle 12c.

It cover 100% of Oracle 12c  exam 1Z0-072 certification syllabus. 

You can find questions more on practical side,they will help you to solve your real time problems.

Exam Topics

Exploring Oracle Database Architecture

• Introducing Oracle Database
• Relational Database Models
• Oracle SQL and PL/SQL
• Connecting to Oracle Databases
• Oracle Database Tools
• Oracle-Supplied User Accounts
• Querying the Oracle Data Dictionary

Managing Database Instances

• Working with Initialization Parameters
• Starting Up Oracle Databases
• Shutting Down Oracle Databases
• Querying Dynamic Performance Views

Configuring the Oracle Network Environment

• Oracle Net Services
• How Listeners Work
• Configuring Listeners for Dynamic Service Registration
• Configuring Local Naming for Connections
• Testing Oracle Net Connectivity with tnsping

Administering User Security

• Creating Users
• Granting Privileges
• Creating and Granting Roles
• Revoking Privileges and Roles
• Creating and Assigning Profiles
• Authenticating Users
• Assigning Quotas to Users

Creating and Managing Tablespaces

• Creating Tablespaces in SQL*Plus
• Altering and Dropping Tablespaces in SQL*Plus
• Viewing Tablespace Information in SQL*Plus
• Implementing Oracle Managed Files
• Moving or Renaming Online Data Files in SQL*Plus

Managing Storage Space

• Types of Segments
• Allocating Extents
• Understanding Deferred Segment Creation
• Monitoring Tablespace Space Usage
• Reclaiming Space by Shrinking Segments

Managing UNDO Data

• Undo Data: Overview
• Configuring Undo Retention
• Guaranteeing Undo Retention
• Changing an Undo Tablespace to a Fixed Size
• Viewing Undo Information
• Viewing Undo Activity

Moving Data

• Moving Data: General Architecture
• Oracle Data Pump: Overview
• Oracle Data Pump: Benefits
• Data Pump Export and Import Clients
• Data Pump Utility: Interfaces and Modes
• SQL*Loader Overview
• Loading Methods
• SQL*Loader Express Mode

Backup and Recovery Concepts

• DBA Responsibities
• Categories of Failure
• Understanding Instance Recovery
• Understanding Types of Backups
• Comparing Complete and Incomplete Recovery
• Oracle Data Protection Solutions
• Flashback Technology

Monitoring and Tuning Database Performance

• Performance Management Activities
• Performance Planning Considerations
• Database Maintenance
• Managing Memory Components

Tuning SQL

• SQL Tuning Process

Introduction to Oracle Database Cloud Service

• Database Cloud Service Offerings
• DBCS Architecture
• Features and Tooling

Managing DBCS Database Deployments

• Managing Network Access to DBCS

Backing Up and Restoring DBCS Database Deployments

• Backup and Recovery tools and concepts 

Creating an Oracle Database by Using DBCA

• Choosing and using Appropriate Character Sets 
• Using DBCA to Create and delete Databases and templates and for other tasks

Upgrading to Oracle Database 12c

• Upgrading by Using the Database Upgrade Assistant (DBUA)
• Manually Upgrading to Oracle Database 12c