How to prepare for 1Z0-052 exam.

Nearly fifty eight objectives have been specified for 1z0-052 (Oracle Database 11g: Administration I) test. To appear for this certification test a candidate must posses a sound knowledge about the architecture of Oracle. One must also know Oracle’s architectural components and database structure before taking the test. One should also be capable of managing storage structures within a database in order to keep the database up to date. Practicing the following things can help a candidate clearly understand these points and pass the test confidently:

1. Know Oracle product family.
2. Explain Relational structures.
3. Understand the SQL language.
4. Describe the single-instance architecture.
5. Explain the memory structures.
6. Describe the process structures.
7. Identify the tools for administering an Oracle database.
8. Plan an Oracle database installation.
9. Install the Oracle software by using Oracle.
10. Create a database by using the DBCA.
11. Describe the stages of database startup and shutdown.
12. Set database initialization parameters.
13. Use the trace files and alert log.
14. Use data dictionary and dynamic performance views.
15. Configure and manage the Oracle network.
16. Use the Oracle shared server architecture.
17. Understand tablespaces and data files.
18. Create and manage tablespaces.
19. Manage space in tablespaces.
20. Create and manage database user accounts.
21. Grant and revoke privileges.
22. Create and manage roles.
23. Create and manage profiles.
24. Create and modify tables.
25. Manage constraints.
26. Create indexes.
27. Create and use temporary tables.
28. Manage data using DML.
29. Identify and administer PL/SQL objects.
30. Monitor and resolve locking conflicts.
31. Explain the purpose of undo.
32. Understand how transactions generate undo.
33. Implement database security and principle of least privilege.
34. Work with standard database auditing.
35. Use and manage Optimizer statistics.
36. Use and manage the Automatic Workload Repository.
37. Use the Advisory Framework.
38. Manage alerts and thresholds.
39. Use Automatic Memory Management.
40. Use Memory Advisor.
41. Troubleshoot invalid and unusable objects.
42. Identify the types of failure that can occur.
43. Describe ways to tune instance recovery.
44. Identify the importance of checkpoints, redo log files, and archived log files.
45. Configure ARCHIVELOG mode.
46. Create consistent database backups.
47. Back up your database without shutting it down.
48. Create Incremental backups.
49. Automate database backups.
50. Manage backups, view backup reports, and monitor the Flash Recovery Area.
51. Use data recovery advisor to perform recovery.
52. Describe and use methods to move data.
53. Use Data Pump Export and Import to move data between Oracle databases.
54. Use the Enterprise Manager support workbench.
55. Manage patches.

• Previous Entry: How to prepare for 70-447 exam
• Next Entry: How to prepare for 70-291 exam