Candidates need to practice the following 58 things to successfully pass the Oracle Database 11g: New Features for Administrators (1Z0-050) examination:
- Install Oracle Database 11g.
- Upgrade your database to Oracle Database 11g.
- Oracle direct NFS
- Use online patching.
- Set up ASM fast mirror resynch.
- Understand scalability and performance enhancements.
- Set up ASM disk group attributes.
- Use various new manageability options.
- Use the md_backup, md_restore, and ASMCMD extensions.
- Create and use AWR baselines.
- Set AWR baseline metric thresholds.
- Control automated maintenance tasks.
- Use Database Resource Manager new features.
- Use new scheduler features.
- ADDM enhancements.
- Set up Automatic Memory Management.
- Enhancements in statistics collection.
- Implement the new partitioning methods.
- Employ data compression.
- SQL Access Advisor Overview.
- Create SQL Access Advisor analysis session using PL/SQL.
- Manage Archive logs.
- Duplicate a database.
- Back up large files in multiple sections.
- Perform Archival Backups.
- Manage Recovery Catalogs.
- Create a virtual private catalog for RMAN.
- Overview of Flashback Data Archive.
- Manage Flashback Data Archive.
- Back-out transactions using Flashback Transaction.
- Work with LogMiner.
- Set up Automatic Diagnostic Repository.
- Use Support Workbench.
- Run health checks.
- Use SQL Repair Advisor.
- Overview of workload capture and replay
- Use Workload capture and replay.
- Overview of Data Recovery Advisor
- Repair data failures using Data Recovery Advisor.
- Perform proactive health check of the database.
- Configure the password file to use case sensitive passwords.
- Encrypt a tablespace.
- Configure fined grained access to network services.
- Use Secure File LOBS to store documents with compression, encryption, de-duplication, and caching.
- Use SQL and PL/SQL APIs to access Secure File LOBS.
- Describe and use the enhanced online table redefinition.
- Enhanced finer grained dependency management.
- Use Enhanced DDL – Apply the improved table lock mechanism, create invisible indexes.
- Use Query Result Cache and PL/SQL Result Cache.
- Adaptive cursor sharing
- Temporary tablespace enhancements
- Overview of SQL Performance Analyzer
- Use SQL Performance Analyzer.
- SQL Plan Baseline Architecture
- Set up SQL Plan Baseline.
- Use SQL Plan Baseline.
- Set up and modify Automatic SQL Tuning.
- Interpret reports generated by Automatic SQL Tuning.