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
No comments:
Post a Comment