1z0-007 content q.

[antman03]

Hi all,

I'm preparing for the 1z0-007 test and I've got a sybex study guie by Dawes and Thomas. It describes the various single-line functions available in Oracle, and being someone who doesn't have much mathetical experience, some of them are quite bewildering.

My question is what is the level of knowledge of these functions in the exam? I can see a problem arising about knowing when to apply a certain function (math knowledge) and whether this function exists in Oracle (oracle knowledge)

Also the environment variables. Do they have to be memorized as well (they are a lot of them and I can't see any mention of them in the Test Content Checklist from Oracle)?

TIA

 

[markrem]

In terms of what you need to know about the SQL*Plus environment variables, your Sybex book is very good. I used the same books to pass all four of my OCP exams. Consider this example I just made up, "What is the result in SQL*Plus 9.2 when the user issues the command SET TIME '11:47:00';?"
a. The database time is reset to 11:47:00
b. The system clock is reset to 11:47:00.
c. There is no TIME variable.
d. None of the above.

Obviously, the answer is "d. none of the above." An error is returned because you can only set time to a value of on or off, but not to a time value. You should be familiar with the SET, SHOW, and DEFINE commands. You should be familiar with variables and allowable values.

The functions on the exam changes from time to time. I saw a few I never bothered to study because they were abstract and I've never had cause to use them in real life (10 years of DBA work.) I don't know if those were scored or unscored questions on the exam.

Regarding the Sybex books, be sure to go to their web site and get the errata pages. There are typo's in all four books, and the fixes are posted on the errata pages.

-Mark

9i OCP