Things to practice for Oracle test 1z0-053

The Oracle test 1z0-053 is designed to measure an individual’s ability to administer Oracle Database 11g. Before taking the 1z0-053 test, you should practice the following:

1. Describe Automatic Storage Management (ASM).
2. Set up initialization parameter files for ASM and database instances.
3. Start up and shut down ASM instances.
4. Administer ASM disk groups.
5. Configure multiple archive log file destinations to increase availability.
6. Define, apply, and use a retention policy.
7. Configure the Flash Recovery Area.
8. Use Flash Recovery Area.
9. Identify situations that require RMAN recovery catalog.
10. Create and configure a recovery catalog.
11. Synchronize the recovery catalog.
12. Create and use RMAN stored scripts.
13. Back up the recovery catalog.
14. Create and use a virtual private catalog.
15. Configure backup settings.
16. Allocate channels to use in backing up.
17. Configure backup optimization.
18. Create image file backups.
19. Create a whole database backup.
20. Enable fast incremental backup.
21. Create duplex backup and back up backup sets.
22. Create an archival backup for long-term retention.
23. Create a multi-section, compressed and encrypted backup.
24. Report on and maintain backups.
25. Recover from a lost TEMP file.
26. Recover from a lost redo log group.
27. Recover from the loss of a password file.
28. Perform user-managed complete database recovery.
29. Perform user-managed incomplete database recovery.
30. Perform user-managed and server managed backups.
31. Identify the need of backup mode.
32. Back up and recover a control file.
33. Perform complete recovery from a critical or non-critical data file loss using RMAN.
34. Perform incomplete recovery using RMAN.
35. Recover using incrementally updated backups.
36. Switch to image copies for fast recovery.
37. Restore a database onto a new host.
38. Recover using a backup control file.
39. Perform Disaster recovery.
40. Create a duplicate database.
41. Use a duplicate database.
42. Identify the situations that require TSPITR.
43. Perform automated TSPITR.
44. Monitor RMAN sessions and jobs.
45. Tune RMAN.
46. Configure RMAN for Asynchronous I/O.
47. Restore dropped tables from the recycle bin.
48. Perform Flashback Query.
49. Use Flashback Transaction.
50. Perform Flashback Table operations.
51. Configure and Monitor Flashback Database, and Perform Flashback Database operations.
52. Set up and use a Flashback Data Archive.
53. Set up Automatic Diagnostic Repository.
54. Use Support Workbench.
55. Perform Block Media Recovery.
56. Implement Automatic Memory Management.
57. Manually configure SGA parameters.
58. Configure automatic PGA memory management.
59. Use the SQL Tune Advisor.
60. Use the SQL Access Advisor to tune a workload.
61. Understand Database Replay.
62. Manage resumable space allocation.
63. Describe the concepts of transportable tablespaces and databases.
64. Reclaim wasted space from tables and indexes by using the segment shrink functionality.
65. Understand the database resource manager.
66. Create and use Database Resource Manager Components.
67. Create a job, program, and schedule.
68. Use a time-based or event-based schedule for executing Scheduler jobs.
69. Create lightweight jobs.
70. Use job chains to perform a series of related tasks.
71. Create Windows and Job Classes.
72. Use advanced Scheduler concepts to prioritize jobs.
73. Customize language-dependent behavior for the database and individual sessions.
74. Work with database and NLS character sets.