Archive for the ‘Exam passing tips’ category

This test requires a thorough knowledge of administrative tasks for managing the database for optimal performance. The candidate appearing in this test should have a sound knowledge of various tools available in Oracle9i for managing different issues in the database. This includes identifying contentions and resolving them through the tools. For this purpose, one should practice the following to a good extent:

1. Identifying tuning areas through querying the available views.
2. Gathering statistics through available tools, such as STATSPACK.
3. Using the available GUI tools, such as Instance Manager to resolve contentions.

The 1Z0-147 (Oracle9i: Program with PL/SQL) test focuses on a candidate’s ability to develop applications by using the PL/SQL. It requires the candidate to have a good command over PL/SQL. One should be capable of understanding the requirements of an application and program accordingly. Before appearing for the test, one must be well familiar with the objectives declared for the test. Along with going through books and taking practice tests, a candidate should also do a lot of hands-on work on programming. Practicing the following things can help a candidate clearly understand the concepts of PL/SQL programming and pass the test confidently:

1. Define and execute PL/SQL blocks.
2. Use %TYPE attribute to define the datatypes of variables.
3. Insert, update, delete, and query data from tables with the help of PL/SQL programs.
4. Practice defining and raising exceptions in PL/SQL programs.
5. Create and execute procedures.
6. Create and execute functions.
7. Invoke functions in SQL expressions.
8. Create packages.