Oracle Database 11g: Administration I

Oracle Database 11g: Administration I

The Oracle Database 11g Administrator I (1Z0-052) exam is primarily intended for Oracle Database 11g administrators, that have a strong foundation and expertise in the industry’s most advanced database management system.
 

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. Prerequisites or additional requirements apply. Please click on the certification link for further clarification. This certification helps their companies qualify for the Oracle Database Specialization.

Exam Number:
1Z0-052
Duration:
90 minutes
Associated Certifications:
Oracle Database 11g Administrator Certified Associate

OPN Certified Specialist
Number of
Questions:
70
Exam Price:
US $195
Pricing may vary slightly by country or by localized currency. Check Pearson VUE’s website for exact pricing in your country.
Passing
Score:
66%

Passing score subject to change. View Details
Click Here to Register:
Register

 

Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy


Recommended Training
Oracle Database 11g Administration I - Exam Study Guide

OPN Guided Learning Path
Oracle Database 11g Implementation Specialist

Oracle University Training
Oracle Database 11g: Administration Workshop I DBA Release 2

 

 

Additional Information & Resources

Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)
Sample Questions

Practice Exams

The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0

 

 

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 Data and Concurrency

  • 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.
 

 

 E-mail this page  Printer View