Oracle has designed 1z0-045 (Oracle Database 10g DBA New Features for Oracle8i OCPs) as an upgrade certification test, which helps you to upgrade from an Oracle 8i Certified Professional to an Oracle 10g Certified Professional (OCP). Apart from studying books and taking various practice tests, you should also practice with Oracle 10g software, which will be of great importance from the test point of view.
Before taking this exam, you should practice the following:
- Install Oracle 10g.
- Use EM to perform various activities pertaining to a database.
- Use data pump commands to import and export data.
- Identify advisor’s recommendations to manage the space within a database.
- Recognize and manage the server-generated alerts.
- Automate tasks with scheduler.
- Define VLDB supports.
- Perform database backup and recovery with enhanced features.
Continue reading “Things to practice for Oracle test 1Z0-045.”