Candidates need to practice the following 58 things to successfully pass the Oracle Database 11g: New Features for Administrators (1Z0-050) examination:

  1. Install Oracle Database 11g.
  2. Upgrade your database to Oracle Database 11g.
  3. Oracle direct NFS
  4. Use online patching.
  5. Set up ASM fast mirror resynch.
  6. Understand scalability and performance enhancements.
  7. Set up ASM disk group attributes.
  8. Use various new manageability options.
  9. Use the md_backup, md_restore, and ASMCMD extensions.
  10. Create and use AWR baselines.
  11. Set AWR baseline metric thresholds.
  12. Control automated maintenance tasks.
  13. Use Database Resource Manager new features.
  14. Use new scheduler features.
  15. ADDM enhancements.
  16. Set up Automatic Memory Management.
  17. Enhancements in statistics collection.
  18. Implement the new partitioning methods.
  19. Employ data compression.
  20. SQL Access Advisor Overview.
  21. Create SQL Access Advisor analysis session using PL/SQL.
  22. Manage Archive logs.
  23. Duplicate a database.
  24. Back up large files in multiple sections.
  25. Perform Archival Backups.
  26. Manage Recovery Catalogs.
  27. Create a virtual private catalog for RMAN.
  28. Overview of Flashback Data Archive.
  29. Manage Flashback Data Archive.
  30. Back-out transactions using Flashback Transaction.
  31. Work with LogMiner.
  32. Set up Automatic Diagnostic Repository.
  33. Use Support Workbench.
  34. Run health checks.
  35. Use SQL Repair Advisor.
  36. Overview of workload capture and replay
  37. Use Workload capture and replay.
  38. Overview of Data Recovery Advisor
  39. Repair data failures using Data Recovery Advisor.
  40. Perform proactive health check of the database.
  41. Configure the password file to use case sensitive passwords.
  42. Encrypt a tablespace.
  43. Configure fined grained access to network services.
  44. Use Secure File LOBS to store documents with compression, encryption, de-duplication, and caching.
  45. Use SQL and PL/SQL APIs to access Secure File LOBS.
  46. Describe and use the enhanced online table redefinition.
  47. Enhanced finer grained dependency management.
  48. Use Enhanced DDL – Apply the improved table lock mechanism, create invisible indexes.
  49. Use Query Result Cache and PL/SQL Result Cache.
  50. Adaptive cursor sharing
  51. Temporary tablespace enhancements
  52. Overview of SQL Performance Analyzer
  53. Use SQL Performance Analyzer.
  54. SQL Plan Baseline Architecture
  55. Set up SQL Plan Baseline.
  56. Use SQL Plan Baseline.
  57. Set up and modify Automatic SQL Tuning.
  58. Interpret reports generated by Automatic SQL Tuning.