Passing 1Z0-050 successfully is only a few steps away
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. […]
February 20, 2011
2 min
Author
uCertify
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.