Oracle 11g Admin I Certification - Exam 1Z0-052 Guide

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.