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

> Database > Oracle Database

1 - Examen Topic

1.1 - Exploring the Oracle Database Architecture

  • Explain the Memory Structures
  • Describe the Process Structures
  • Overview of Storage Structures
Advertising

1.2 - 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)

1.3 - Creating an Oracle Database

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

1.4 - 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

1.5 - Configuring the Oracle Network Environment

  • Configure and Manage the Oracle Network
  • Using the Oracle Shared Server architecture
Advertising

1.6 - Managing Database Storage Structures

  • Overview of tablespace and datafiles
  • Create and manage tablespaces
  • Space management in tablespaces

1.7 - Administering User Security

  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

1.8 - Managing Data and Concurrency

  • Monitor and resolve locking conflicts

1.9 - Managing Undo Data

  • Overview of Undo
  • Transactions and undo data
  • Managing undo
Advertising

1.10 - Implementing Oracle Database Security

  • Database Security and Principle of Least Privilege
  • Work with Standard Database Auditing

1.11 - Database Maintenance

  • Use and manage optimizer statistics
  • Use and manage Automatic Workload Repository (AWR)
  • Use advisory framework
  • Manage Alerts and Thresholds

1.12 - Performance Management

  • Use Automatic Memory Management
  • Use Memory Advisors
  • Troubleshoot invalid and unusable objects

1.13 - Intelligent Infrastructure Enhancements

  • Use the Enterprise Manager Support Workbench
  • Managing Patches

1.14 - 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

1.15 - 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

1.16 - Performing Database Recovery

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

1.17 - 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

2 - Documentation / Reference