Oracle 1Z0-055 Certification Exam Syllabus

1Z0-055 Syllabus, 1Z0-055 Dumps PDF, Oracle OCP Dumps, 1Z0-055 Dumps Free Download PDF, Oracle Database OCP Dumps, 1Z0-055 Latest Dumps Free DownloadYou can use this exam guide to collect all the information about Oracle Database 11g - New Features for 9i OCPs (1Z0-055) certification. The Oracle 1Z0-055 certification is mainly targeted to those candidates who has some experience or exposure of Oracle Database and want to flourish their career with Oracle Database 11g Administrator Certified Professional (OCP) credential. The Oracle Database 11g - New Features for 9i OCPs certification exam validates your understanding of the Oracle Database technology and sets the stage for your future progression. Your preparation plan for Oracle 1Z0-055 Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following Certification Exam Topics table.

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 (Pricing may vary by country or by localized currency)
Duration 120 minutes
Number of Questions 84
Passing Score 61%
Validated Against The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0.
Format Multiple Choice
Recommended Training Oracle Database 11g: New Features for Administrators
Oracle Database 11g: New Features for Oracle 9i DBAs
Schedule Exam Pearson VUE - Oracle
Recommended Practice 1Z0-055 Online Practice Exam

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
Caching - 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

The Oracle 1Z0-055 Certification Program certifies candidates on skills and knowledge related to Oracle Database products and technologies. The Oracle Database 11g Administrator Certified Professional is granted based on a combination of passing exams, training and performance-based assignments, depending on the level of certification. Oracle 1Z0-055 certification is tangible benchmark of experience and expertise that help you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exam and hands-on experience to prepare for your Oracle Database 11g - New Features for 9i OCPs certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.

Rating: 5 / 5 (20 votes)