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