Monday, March 22, 2010

Oracle Database 11g: Administration I - 1Z0-052

This is the subject matter according the the Oracle website for the Oracle Database 11g Administration I test (OCA). You can find it here. I've also created a "clean" version of it here.

Here's the list of books (Oracle Documentation) I have used.

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

1 comment:

Unknown said...

Excellent Source of Information!! hats off !!!