Skills required for Oracle test 1Z0-043

Skills required for Oracle test 1Z0-043

Rating:

Oracle has specified 59 objectives under 14 topics for 1Z0-043 (Oracle 10g Administration-II). A candidate is required to have an excellent command over the following areas to qualify the test:

1. Knowing about RMAN.
2. Starting RMAN.
3. Configuring RMAN.
4. Using RMAN commands.
5. Knowing about Globalization support.
6. Understanding the concept of Globalization support.
7. Managing backup and image copies taken with RMAN.
8. Using the datatime datatype.
9. Using linguistic sort parameters.
10. Using linguistic searches.
11. Recovering from user errors.
12. Knowing about Flashback technologies.
13. Using Flashback technologies.
14. Knowing about the logical storage structure called the Recycle Bin.
15. Managing the database corruption.
16. Using various utilities such as ANALYZE and DBVERIFY.
17. Using the DBMS_REPAIR package.
18. Estimating the size of new tablespaces and indexes.
19. Knowing about advisors.
20. Knowing about automatic database management.
21. Knowing about the LIST and REPORT commands.
22. Configuring SGA parameters manually.
23. Recovering temporary tablespaces, redo log files, index tablespaces, and read only tablespaces.
24. Monitoring and managing database storage.
25. Knowing about ASM.
26. Starting and shutting down an ASM instance.
27. Administering ASM disk group.
28. Monitoring and managing memory.
29. Knowing about database recovery.
30. Using EM, RMAN, and SQL for incomplete recovery.
31. Using segment shrink functionality.
32. Knowing about the RESETLOGS operation.
33. Understanding the Flashback database.
34. Knowing about the database Resource Manager.
35. Assigning users to the Resource Manager group.
36. Managing tasks with the Oracle scheduler.
37. Creating job, schedule, program, and window.
38. Retrieving information for job execution and its instances.

Rating: