Esta página tem a intenção de tratar sobre os assuntos da prova 1Z0-052, que cobre sobre assuntos à administração sobre o banco de dados Oracle 11g

O conteúdo sobre a certificação 1Z0-052, de acordo com o site da Oracle, pode ser encontrado em: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-052

O livro utilizado como referencia será: OCA Oracle Database 11g – Administração I (Guia do Exame 1Z0-052) – Preparação completa para o exame, WATSON John, Oracle Press, 2010.

Apesar de parecer um livro velho para os dias atuais, a Oracle até o momento aceita a fazer as provas de certificação para este exame.

De maneira alguma, é recomendado estudar somente por este blog para a certificação, já que muitas informações do livro não são colocadas aqui.  Use somente para complemento dos seus estudos.

Conteúdo abordado:

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 – POST
• Plan an Oracle Database installation – POST
• Install the Oracle software by using Oracle Universal Installer (OUI) – POST

Off Topics

• Creating on Virtual Box the environment to install Oracle Linux 7 – Part 01 – POST
• Installing Oracle Enterprise Linux 7 (OEL) on environment created by Virtual Box – Part 02 – POST
• Configuring Oracle Enterprise Linux 7 environment for Oracle Database 11g installation – Part 03 – POST
• Expanding virtual machine resources to use ASM – Part 04 – POST
• Installing and configuring disks with fdisk and oracleasm commands – Part 05 – POST

Creating an Oracle Database

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

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