Oracle Database 11g: Administration I

Exam Number:	1Z0-052
Associated Certifications:	Oracle Database 11g Administrator Certified Associate OPN Certified Specialist
Exam Price:	$125 US
Exam Registration:	Register

Duration:

90 minutes

Number of Questions:

Passing Score:

66%

Passing score subject to change. View Details

Recommended Training and Preparation

Oracle Database 11g: Administration I
OR
Oracle Database 11g: Administration Workshop I Ed 1.1 LWC

Training Opportunities for Oracle Partner Network Members

Additional Information & Resources

Practice Exams

Oracle authorized practice exam from Self Test Software: 1Z0-052 Oracle Database 11g: Administration I
Oracle authorized practice exam from Transcender: Cert-1Z0-052 DBCert: Oracle Database 11g: Administration I

Exam Retake Policy
Sample Questions

Exam Topics

Exploring the Oracle Database Architecture
[ ]	Explain the Memory Structures
[ ]	Describe the Process Structures
[ ]	Overview of Storage Structures
Preparing the Database Environment
[ ]	Identify the tools for Administering an Oracle Database
[ ]	Plan an Oracle Database installation
[ ]	Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
[ ]	Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
[ ]	Setting database initialization parameters
[ ]	Describe the stages of database startup and shutdown
[ ]	Using alert log and trace files
[ ]	Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
[ ]	Configure and Manage the Oracle Network
[ ]	Using the Oracle Shared Server architecture
Managing Database Storage Structures
[ ]	Overview of tablespace and datafiles
[ ]	Create and manage tablespaces
[ ]	Space management in tablespaces
Administering User Security
[ ]	Create and manage database user accounts
[ ]	Grant and revoke privileges
[ ]	Create and manage roles
[ ]	Create and manage profiles

Managing Schema Objects
[ ]	Create and Modify tables
[ ]	Manage Constraints
[ ]	Create indexes
[ ]	Create and use temporary tables
Managing Data and Concurrency
[ ]	Manage data using DML
[ ]	Identify and administer PL/SQL objects
[ ]	Monitor and resolve locking conflicts
Managing Undo Data
[ ]	Overview of Undo
[ ]	Transactions and undo data
[ ]	Managing undo
Implementing Oracle Database Security
[ ]	Database Security and Principle of Least Privilege
[ ]	Work with Standard Database Auditing
Database Maintenance
[ ]	Use and manage optimizer statistics
[ ]	Use and manage Automatic Workload Repository� (AWR)
[ ]	Use advisory framework
[ ]	Manage Alerts and Thresholds
Performance Management
[ ]	Use Automatic Memory Management
[ ]	Use Memory Advisors
[ ]	Troubleshoot invalid and unusable objects
Intelligent Infrastructure Enhancements
[ ]	Use the Enterprise Manager Support Workbench
[ ]	Managing Patches

Backup and Recovery Concepts
[ ]	Identify the types of failure that can occur in an Oracle database
[ ]	Describe ways to tune instance recovery
[ ]	Identify the importance of checkpoints, redo log files, and archived log files
[ ]	Overview of flash recovery area
[ ]	Configure ARCHIVELOG mode
Performing Database Backups
[ ]	Create consistent database backups
[ ]	Back up your database without shutting it down
[ ]	Create incremental backups
[ ]	Automate database backups
[ ]	Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery
[ ]	Overview of Data Recovery Advisor
[ ]	Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
[ ]	Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
[ ]	Explain the general architecture of Oracle Data Pump
[ ]	Use Data Pump Export and Import to move data between Oracle databases

Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.