Q. What is the pre-requisite for taking the 1z0-040 test?

A. The prerequisite for the 1z0-040 test is Oracle Database 10g: New Features for Administrators Release 2 (1z0-030). The 1z0-040 (OCP) is a step that upgrades your 9i OCP credential to 10g credential. Generally, one test is required for OCPs to upgrade to each new release of an Oracle DBA track. The Oracle Database 10g certification track is a step towards a successful career as an Oracle professional. However, you must be well experienced with the SQL before you take the test. Self-studying and self-schooling can certainly help you prepare for the test. This will require a lot of dedication and practice managing a database and newly added features in 10g.

Q. How can you register for the test?

A. Register yourself through the registered PearsonVUE testing center. After getting yourself registered for the test, you can contact the testing center to know the schedule (date and time) of your test. Oracle certifications can be taken only at authorized PearsonVUE centers world-wide. The test date may depend on your choice (and availability of slot) in your selected test center. You may choose to register yourself online at http://www.pearsonvue.com/oracle/

Continue reading

Oracle has designed 1z0-040 (Oracle Database 10g: New features for Administrators) as an upgrade certification test, which helps you to upgrade from an Oracle 9i Certified Professional to an Oracle 10g Certified Professional (OCP). Apart from studying books and taking various practice tests, you should also practice with Oracle software. While practicing with Oracle, you can learn a lot of things of great importance from the test point of view.

Before taking this exam, you should practice the following:

  1. Install Oracle 10g.
  2. Define policy-based database configuration framework.
  3. Use EM to perform various activities pertaining to a database.
  4. Use data pump commands to import and export data.
  5. Identify advisor’s recommendations to manage the space within a database.
  6. Recognize and manage the server-generated alerts.
  7. Automate tasks with scheduler.
  8. Continue reading

uCertify (Nov 21, 2008). uCertify, a leading provider of exam preparation software for IT certification exams, today announced huge discount of 37.23% on the entire range of its practice tests. This discount offer is valid only until Sunday, November 30th, 2008. uCertify also offers unconditional 100% money back guarantee, on all its products. You will pass or we will return your money.

“You can now purchase uCertify practice tests for MCSE, MCITP, MCTS, SCJP, A+, CIW, OCP and other certifications and save 37.23% on the regular price. This is the lowest price of the year and you are advised to take advantage of this limited period opportunity now,”said Mark Smith, Director, Product Management, uCertify. Continue reading

New Features of Oracle 10g, Oracle 10g Installation, Server Configuration, and Maintenance of the Software

  • Memory – 512MB, Temp space – 400MB of free space in the /tmp directory applicable for the Unix operating system, Swap space – 1GB or twice the amount of RAM, Free disk space – 1.5GB are the minimum hardware requirements to install Oracle 10g.
  • The Installation Type list box is used to decide the type of installation.
  • Oracle Management Agent (OMA) is a centralized administrative tool that is capable of administering the database server and an application server.
  • The location (/u01/app/oracle) will be considered as the base of Optimal Flexible Architecture (OFA).
  • The password file is used to authenticate the administrative tasks from remote locations.
  • An Oracle 10g client can be used to connect to an Oracle 8i or 9i database by using the following syntax:
    Continue reading

Q. What is the pre-requisite for taking the 1Z0-040 test?

A. The prerequisite for the 1Z0-040 test is Oracle Database 10g: New Features for Administrators Release 2 (1z0-030). The 1Z0-040 (OCP) is a step that upgrades your 9i OCP credential to 10g credential. Generally, one test is required for OCPs to upgrade to each new release of an Oracle DBA track. The Oracle Database 10g certification track is a step towards a successful career as an Oracle professional. However, you must be well experienced with the SQL before you take the test. Self-studying and self-schooling can certainly help you prepare for the test. This will require a lot of dedication and practice managing a database and newly added features in 10g.

Q. How can you register for the test?

Continue reading