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

Explain the Memory Structures

Describe the Process Structures

Overview of Storage Structures

Identify the tools for Administering an Oracle Database

Plan an Oracle Database installation

Install the Oracle software by using Oracle Universal Installer (OUI)

Create a database by using the Database Configuration Assistant (DBCA)

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

Configure and Manage the Oracle Network

Using the Oracle Shared Server architecture

Overview of tablespace and datafiles

Create and manage tablespaces

Space management in tablespaces

Create and manage database user accounts

Grant and revoke privileges

Create and manage roles

Create and manage profiles

Monitor and resolve locking conflicts

Overview of Undo

Transactions and undo data

Managing undo

Database Security and Principle of Least Privilege

Work with Standard Database Auditing

Use and manage optimizer statistics

Use and manage Automatic Workload Repository (AWR)

Use advisory framework

Manage Alerts and Thresholds

Use Automatic Memory Management

Use Memory Advisors

Troubleshoot invalid and unusable objects

Use the Enterprise Manager Support Workbench

Managing Patches

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

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

Overview of Data Recovery Advisor

Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

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