Código: 1Z0-062

Prova	Oracle Database 12c: Installation and Administration
Preço	US$ 245.00
Duração	150 minutos
Número de questões	70 – Múltipla Escolha
Nota de aprovação	67%
Treinamento oficial recomendado	Oracle Database 12c: Admin, Install and Upgrade Accelerated

Tópicos do exame

 

Oracle Database Administration

 

• List the architectural components of Oracle Database
• Explain the memory structures
• Describe the background processes
• Explain the relationship between logical and physical storage structures

• Configure Oracle Net Services
• Use tools for configuring and managing the Oracle network
• Configure client-side network
• Understand database resident connection pooling
• Configure communication between databases

• Describe the storage of table row data in blocks
• Create and manage tablespaces

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

• Explain how Oracle database server automatically manages space
• Save space by using compression
• Proactively monitor and manage tablespace space usage
• Use the Segment Advisor
• Reclaim wasted space from tables and indexes by using the segment shrink functionality
• Manage resumable space allocation

• Explain DML and undo data generation
• Monitor and administer undo data
• Describe the difference between undo data and redo data
• Configure undo retention

• Describe the locking mechanism and how Oracle manages data concurrency
• Monitor and resolve locking conflicts

• Explain DBA responsibilities for security and auditing
• Enable standard database auditing and unified auditing

• Identify the importance of checkpoints, redo log files, and archive log files

• Configure the fast 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

• Determine the need for performing recovery
• Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file

• Describe ways to move data
• Use SQL*Loader to load data from a non-Oracle database
• Use external tables to move data via platform-independent files
• Use Data Pump Export and Import to move data between Oracle databases

• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Set alert thresholds
• Use automated tasks

• Use Enterprise Manager to monitor performance
• Use Automatic Memory Management
• Use the Memory Advisor to size memory buffers

 

Installing, Upgrading and Patching the Oracle Database

 

• Plan for an Oracle Database software installation

• Configure storage for Oracle Automatic Storage Management (ASM)
• Install Oracle Grid Infrastructure for a standalone server

• Install the Oracle Database software

• Create a database by using the Database Configuration Assistant (DBCA)
• Generate database creation scripts by using DBCA
• Manage database design templates by using DBCA
• Configure database options by using DBCA

• Use Oracle Restart to manage components

• Describe upgrade methods
• Describe data migration methods
• Describe the upgrade process

• Describe upgrade requirements when certain features or options are used in Oracle Database
• Use the pre-upgrade information tool before performing an upgrade
• Prepare the new Oracle home prior to performing an upgrade

• Upgrade the database to Oracle Database 12c by using the Database Upgrade Assistant (DBUA)
• Perform a manual upgrade to Oracle Database 12c by using scripts and tools

• Migrate to unified auditing
• Perform post-upgrade tasks