1Z0-055: Oracle Database 11g - New Features for 9i OCPs

Exam Number: 1Z0-055

Exam Title: Oracle Database 11g - New Features for 9i OCPs

Associated Certification Paths

Oracle 1Z0-055 Certification Details:

Exam Name Oracle Database 11g - New Features for 9i OCPs
Exam Code 1Z0-055
Exam Product Version Oracle Database 11g
Exam Price USD $245
Duration 120 minutes
Number of Questions 84
Passing Score 61%
Validated Against The exam has been validated against Oracle® Database 11g Release 2 version
Format Multiple Choice
Recommended Practice 1Z0-055 Online Practice Exam
Recommended Training Oracle Database 11g: New Features for Administrators AND Oracle Database 10g: New Features for Administrators Release 2 or
Oracle Database 11g: New Features for Oracle 9i DBAs

Oracle 1Z0-055 Certification Topics:

Installation and Upgrade Enhancements 
  • Install Oracle Database 11g
  • Upgrade your database to Oracle Database 11g 
  • Use online patching
Storage Enhancements
  • Create and maintain bigfile tablespaces
  • Rename tablespaces 
  • Create a default permanent tablespace 
  • Describe Automatic Storage Management (ASM)  
  • Set up initialization parameter files for ASM and database instances 
  • Execute SQL commands with ASM file names 
  • Use ASMCMD Command-Line Interface 
  • Start up and shut down ASM instances 
  • Administer ASM disk groups 
  • Setup ASM fast mirror resynch 
  • Understand scalability and performance enhancements
SQL Performance Analyzer
  • Using SQL Performance Analyzer
SQL Plan Management
  • SQL Plan Baseline Architecture
  • Set up SQL Plan Baseline 
  • Using SQL Plan Baseline
Database Replay 
  • Overview of Workload Capture and Replay
  • Using Workload capture and replay
Miscellaneous New Features 
  • Describe and use the enhanced online table redefinition
  • Use fine-grained auditing for DML statements 
  • Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes 
  • Use Query Result Cache and PL/SQL Result Cache 
  • Create temporary tablespace groups 
  • Assign temporary tablespace groups to users 
  • Temporary Tablespace Enhancements
Oracle SecureFiles 
  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication
  • Use SQL and PL/SQL APIs to access Secure File LOBS
SQL Tuning 
  • Use the SQL Tuning Advisor
  • SQL Access Advisor Overview 
  • Create SQL Access Advisor analysis session using PL/SQL 
  • Setup and modify Automatic SQL Tuning 
  • Interpret reports generated by Automatic SQL Tuning 
  • Use SQL Repair Advisor
Intelligent Infrastructure Enhancements 
  • Monitor and maintain the AWR
  • Creating and using AWR baselines 
  • Control Automated Maintenance Tasks  
  • Using Database Resource Manager New Features 
  • Simplify management tasks by using the Scheduler 
  • Create a job, program, schedule and window 
  • View information about job executions and job instances 
  • Monitor and manage server-generated alerts
Performance Enhancements
  • Use Automatic Database Diagnostic Monitor (ADDM)
  • ADDM Enhancments in 11g 
  • Use Automatic Shared Memory Management 
  • Setup Automatic Memory Management 
  • Enhancements in statistics collection
Space Management and Partitioning 
  • Reduce space related error conditions through proactively managing tablespace usage
  • Reclaim wasted space from tables and indexes using the segment shrink functionality 
  • Use the Segment Advisor 
  • Use the Undo Advisor 
  • Use Automatic Undo Retention Tuning 
  • Implement the new partitioning methods  
  • Employ Data Compression
Load and Unload Data 
  • Transport tablespaces across different platforms
  • Explain Data Pump architecture 
  • Monitor a Data Pump job 
  • Use Data Pump export and import 
  • Create external tables for data population
Backup and Recovery Enhancements 
  • Simplify file management for all recovery-related file
  • Reduce restore time by applying incremental backups to data file image copies 
  • Simplify recovery after opening the database with the RESETLOGS option 
  • Speed backup times by creating faster incremental backups 
  • Minimize load requirements by specifying limits in backup time windows 
  • Save storage space through writing compressed backup sets 
  • Managing Archive logs
Using Flashback and Logminer
  • Configure and use Flashback Database
  • Recover dropped tables with the Flashback Drop feature 
  • Retrieve row history information with the Flashback Versions Query feature 
  • Audit or recover FROM transactions with the Flashback Transaction Query feature 
  • Recover tables to a point in time with the Flashback Table feature 
  • Back-out transactions using Flashback Transaction
Diagnosability Enhancements
  • Setup Automatic Diagnostic Repository
  • Use Support Workbench 
  • Run health checks
Using the Data Recovery Advisor
  • Overview of Data Recovery Advisor
  • Repairing data failures using Data Recovery Advisor 
  • Perform proactive health check of the database
Security: New Features
  • Configure the password file to use case sensitive passwords
  • Encrypt a tablespace 
  • Configure fined grained access to network services

Oracle 1Z0-055 - Oracle Database 11g - New Features for 9i OCPs Exam Preparation: