OCA SQL exam help

[awsedrftgy]

I have recently this week completed the introduction to oracle 9i SQL intructor led class at Oracle.

I am a little confused as to the material required for the exam. Though the lectures were in depth covering all aspects of the certification, the selfTest software seems more difficult than the questions with the oracle material.

I out to fond out the following:
is the SelfTestSoftware a good guide to the exam format and rigour?
Also does the exam cover topics such as SET Operators, DATETIME functions, ROLLUP, CUBE GROUPING function, Hierachical Retrieval and extensions to DML and DDL?

another point, I am averaging about 75-80% on the selftestsoftware, is this a good enough mark to attempt the real thing?

regards
H

 

[mhusain]

Hi

Check out the following link. This has the course content for 1z0-001. This tell u what topics will be on the test.
Use this as a guideline.

http://www.oracle.com/education/certification/objectives/index.html?7.html

As a rule of thumb u need to score above 95% on STS before u r ready for the real test.

Good Luck