1Z0-052: Oracle Database 11g - Administration I

Exam Number: 1Z0-052

Exam Title: Oracle Database 11g - Administration I

Associated Certification Paths

Oracle 1Z0-052 Certification Details:

Exam Name Oracle Database 11g - Administration I
Exam Code 1Z0-052
Exam Product Version Oracle Database 11g
Exam Price USD $245
Duration 90 minutes
Number of Questions 70
Passing Score 66%
Validated Against The exam has been validated against Oracle® Database 11g Release 2 version
Format Multiple Choice
Recommended Practice 1Z0-052 Online Practice Exam
Recommended Training Oracle Database 11g: Administration Workshop I

Oracle 1Z0-052 Certification Topics:

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

Oracle 1Z0-052 - Oracle Database 11g - Administration I Exam Preparation: