1Z0-062: Oracle Database 12c Administration


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