Full Name: Oracle Database 12c Administration
Exam Code: 1Z0-062
Oracle 1Z0-062 Exam Details:
Exam Name
|
Oracle Database 12c - Administration
|
Exam Code
|
1Z0-062
|
Exam Product Version
|
Oracle Database 12c
|
Exam Price
|
USD $245 (Price may vary by country or by localized currency)
|
Duration
|
120 minutes
|
Number of Questions
|
67
|
Passing Score
|
64%
|
Recommended Training
|
|
Format
|
Multiple Choice Questions (MCQ)
|
Recommended Training
|
|
Recommended Practice
|
Oracle 1Z0-062 Syllabus Topics:
Exploring the Oracle Database Architecture | - List the architectural components of Oracle Database - Explain the memory structures - Describe the background processes |
Oracle Database Management Tools | - Use database management tools |
Oracle Database Instance | - Understand initialization parameter files - Start up and shut down an Oracle database instance - View the alert log and access dynamic performance views |
Configuring the Oracle Network Environment | - Configure Oracle Net Services - Use tools for configuring and managing the Oracle network - Configure client-side network - Configure communication between databases |
Administering User Security | - Create and manage database user accounts - Grant and revoke privileges - Create and manage roles - Create and manage profiles |
Managing Database Storage Structures | - Describe the storage of table row data in blocks - Create and manage tablespaces |
Create and manage tablespaces | - Explain how Oracle database server automatically manages space - Save space by using compression - Use the Segment Advisor - Reclaim wasted space from tables and indexes by using the segment shrink functionality |
Managing Undo Data | - Explain DML and undo data generation - Monitor and administer undo data - Describe the difference between undo data and redo data - Configure undo retention |
Managing Data Concurrency | - Describe the locking mechanism and how Oracle manages data concurrency - Monitor and resolve locking conflicts |
Implementing Oracle Database Auditing | - Enable standard database auditing and unified auditing |
Backup and Recovery Concepts | - Identify the importance of checkpoints, redo log files, and archive log files |
Backup and Recovery Configuration | - Configure the fast 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 |
Performing Database Recovery | - 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 |
Moving Data | - 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 - Explain the general architecture of Oracle Data Pump - Use Data Pump Export and Import to move data between Oracle databases |
Performing Database Maintenance | - Use server-generated alerts |
Managing Performance: SQL Tuning | - Use the SQL Tuning advisor |
Automating Tasks by Using Oracle Scheduler | - Use Oracle Scheduler to simplify management tasks - Use job chains to perform a series of related tasks - Use Scheduler jobs on remote systems - Use advanced Scheduler features to prioritize jobs |
Creating an Oracle Database Using DBCA | - Generate database creation scripts by using DBCA - Manage database design templates by using DBCA |
Upgrading Oracle Database Software | - Describe data migration methods - Describe the upgrade process |
Introduction to DBAAS | - Recognize the difference between a DBaaS Instance and a Database Instance - Navigate with My Services Dashboard - User authentication and roles - Generate a Secure Shell (SSH) Public/Private Key Pair |
0 comments:
Post a Comment