Código: 1Z0-052
| Prova | Oracle Database 11g: Administration I |
| Preço | R$ 326,00 |
| Duração | 90 minutos |
| Número de questões | 70 |
| Nota de aprovação | 66% |
| Treinamento oficial recomendado | Oracle Database 11g: Administration Workshop I |
Tópicos do exame
| 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 | |