Oracle Database 11g Administration I: Preparation for OCA Exam 1Z0-052

You will learn all topics needed for the OCA Exam 1Z0-052 including:

Introduction to Oracle Server Technologies

• Position the Oracle Product Family
• Explain Relational Structures
• Understand the SQL Language
• Appreciate the DBA’s Role

Exploring the Database Architecture

• Describe the Single-Instance Architecture
• Explain the Memory Structures
• Describe the Process Structures
• Summarize the 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 the Oracle Universal Installer (OUI)

Creating an Oracle Database

• Create a Database by Using the Database Configuration Assistant

Managing the Oracle Instance

• Describe the Stages of Database Startup and Shutdown
• Set Database Initialization Parameters
• Use the Alert Log and Trace Files
• Use Data Dictionary and Dynamic Performance Views

Configuring the Oracle Network Environment

• Configure and Manage the Oracle Network
• Use the Oracle Shared Server Architecture

Managing Database Storage Structures

• Understand Tablespaces and Datafiles
• Create and Manage Tablespaces
• Manage Space 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 UndData

• Explain the Purpose of Undo
• Understand How Transactions Generate Undo
• Manage 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 the Automatic Workload Repository
• Use the Advisory Framework
• Manage Alerts and Thresholds

Performance Management

• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot Invalid and Unusable Objects

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 tPerform Recovery (Control File, RedLog File, and Data File)

Moving Data

• Describe and Use Methods tMove Data (Directory Objects, SQL*Loader, External Tables)
• Explain the General Architecture of Oracle Data Pump
• Use Data Pump Export and Import tMove Data Between Oracle Databases

Intelligent Infrastructure Enhancements

• Use the Enterprise Manager Support Workbench
• Manage Patches