The certification test for Oracle 10g Administration-II (1Z0-043) requires thorough understanding of administrative tasks of a database. To clear the 1Z0-043 exam, a candidate must be well versed with the objectives specified for the test. Before taking the test, you should practice the following:
- Configure Recovery Manager.
- Understand Globalization support.
- Use datatime datatypes.
- Use linguistic sort parameters.
- Use linguistic searches.
- Recover from user errors.
- Use various Flashback technologies.
- Understand the Recycle Bin.
- Manage the database corruption.
- Use various utilities such as ANALYZE and DBVERIFY.
- Use the DBMS_REPAIR package.
- Understand Automatic Database Management.
- Recover from non-critical losses.
- Use Recovery Manager.
- Re-create the password file.
- Monitor and manage memory.
- Start up and shut down an instance.
- Administer ASM disk groups.
- Recover a database.
- Understand the Flashback database.
- Manage database resources.
- Automate tasks with Oracle scheduler.
- Retrieve information for job execution and its instances.
- Know about the database Resource Manager.
- Use EM recovery wizard to flashback a database.
- Recover a database after a RESETLOGS operation.