Exam Title: Oracle Database 12cR2 Administration
Exam Number: 1Z0-072
Exam Price: Rs.22,584.00 More on exam pricing
Format: Multiple Choice
Duration: 90 Minutes
Number of Questions: 70
Passing Score: 60%
Validated Against:
Exam Preparation
Complete one of the courses below to prepare for your exam (optional):
Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
Oracle Database 12c R2: Administration Workshop Ed 3
Oracle Database Administration Learning Subscription
Unlimited Product Learning Subscription
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs
and/or field experience) provides the best preparation for passing the exam.
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-072
: Oracle Database 12cR2 Administration (OCA)
Review 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
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
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 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
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
Tuning SQL
SQL Tuning Process
Managing DBCS Database Deployments
Managing Network Access to DBCS
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
Managing Database Instances
Working with Initialization Parameters
Starting Up Oracle Databases
Shutting Down Oracle Databases
Querying Dynamic Performance Views
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
Managing Storage Space
Types of Segments
Allocating Extents
Understanding Deferred Segment Creation
Monitoring Tablespace Space Usage
Reclaiming Space by Shrinking Segments
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
Monitoring and Tuning Database Performance
Performance Management Activities
Performance Planning Considerations
Database Maintenance
Managing Memory Components
Introduction to Oracle Database Cloud Service
Database Cloud Service Offerings
DBCS Architecture
Features and Tooling
Backing Up and Restoring DBCS Database Deployments
Backup and Recovery tools and concepts
Upgrading to Oracle Database 12c
Upgrading by Using the Database Upgrade Assistant (DBUA)
Manually Upgrading to Oracle Database 12c
Click here to
view complete Q&A of 1Z0-072 exam
Certkingdom Review,
Certkingdom PDF Torrents
Best Oracle 1Z0-072 Certification, Oracle 1Z0-072 Training at certkingdom.com