1Z0-072 Oracle Database 12cR2 Administration

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