The certification test for Oracle 1Z0-042 requires sound knowledge of administrative tasks to manage the database. This test demands a thorough knowledge of various administrative tools available in Oracle 10g to manage a database in a very sophisticated manner. The candidate must have a solid understanding of how to back up a database to help in its recovery and one must be very well versed with the objectives specified for the test. Hands-on practice using the software itself can definitely help a candidate in qualifying the test. Practicing especially in the following areas can help raise the confidence level of a candidate:

  1. Know about the architecture of Oracle 10g.
  2. Install Oracle 10g.
  3. Know about various administrative tools to manage the database.
  4. Configure an Oracle network environment.
  5. Work with various database objects.
  6. Configure the Oracle shared server
  7. Implement the database security options.
  8. Manage undo data.
  9. Know the various techniques for database storage
  10. Continue reading

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

A. There is no prerequisite for the 1z0-042 test. The 1z0-042 (OCA) is the first step in the Oracle Database 10g certification track and also the first step towards a successful career as an Oracle professional. However, you must be well experienced with the SQL before you take the test. Even if you are new to the Oracle field, you can still pass the test with self-study or self-schooling. This will require a lot of dedication and practice, managing a database and newly added features in 10g.

Q. How can I 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

What is OCA DBA (10g) certification?

OCA DBA (10g) certification is the most fundamental and entrance level certification on DBA track on 10g platform. Its objectives are intended to measure a candidate’s ability to work as a junior team member with Database Administrators or Application Developers. This certification is the first step towards the more advanced OCP – 10g certification. The certification requires the comprehensive skills in the following areas:

Posted in OCP.

Bob Bryla is an Oracle 8, 8i, 9, 10g and 11g Certified Professional with more than 20 years of experience in database design, database application development, training, and Oracle database administration. He is the primary internet database designer and developer at Lands’ End in Dodgeville, Wisconsin. Bob works with PL/SQL and Oracle on a daily basis to support the back end of the world’s #1 clothing web site, landsend.com.

Bob Bryla Co-Author and contributor for following uCertify PrepKit
1Z0-052 OCA: Oracle Database 11g: Administration I

 

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

Oracle architecture

  • The size of the shared pool can be changed dynamically. The data dictionary cache of the shared pool holds the most recently accessed data dictionary information. The shared pool consists of a library cache and data dictionary cache.
  • Control file, redo log file, and data file are part of an Oracle database.
  • An SGA and Oracle background processes constitute an Oracle instance. An SGA is ended when an Oracle instance is shut down. Multiple users can share data in an SGA.
  • While making modifications in SPFILE, the instance should be in open and running state, whereas in the case of PFILE, the instance will have to be first shut down and restarted before making any modifications in it.
  • V is a dynamic performance view that is used to display the names and the location of all the control files.
  • Following is the correct sequence of the processes that occur when a database is opened:
    1. An initialization parameter file is read.
    2. Continue reading

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

A. There is no prerequisite for the 1z0-042 test. The 1z0-042 (OCA) is the first step in the Oracle Database 10g certification track and also the first step towards a successful career as an Oracle professional. However, you must be well experienced with the SQL before you take the test. Even if you are new to the Oracle field, you can still pass the test with self-study or self-schooling. This will require a lot of dedication and practice, managing a database and newly added features in 10g.

Q. How can I register for the test?

Continue reading

Roy Wood

Roy Wood (esofthub) is a former Airborne and Air Assault trooper in the U.S. Army. Currently residing in South Korea, he blogs about his classified ads website and UNIX related tasks. These UNIX tips are a result of what he has learned throughout his 10-year career as a lead systems engineer for a major U.S. technology company.

Roy reviewed the 1Z0-042 practice test for the OCA 10g certification and found it very useful. He remarked, “I thought the final test was a bit more difficult than the practice tests which was probably by design. Also, I noticed there was a “learn” function for each test question, which was accompanied by a thorough explanation.”

Please read the complete review at My SysAd Blog – UNIX