Re: OCP Question: Oracle 9i introduction

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 10 Jun 2003 12:49:51 -0700
Message-ID: <92eeeff0.0306101149.e8bccdd@posting.google.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<agkFa.53080$1s1.712874_at_newsfeeds.bigpond.com>...
> Hi Norman/Willie,
>
> I think E is (meant to be) incorrect.
>
> It's not Timestamp with *database* time zone but Timestamp with *local* time
> zone (or simply Timestamp).
>
> Don't you just love these questions ....
>

I think OCP exams should be geared more towards "How to effectively use online Oracle documentation and Google search to get to correct answer quick"... instead of memorizing syntax and datatypes and perhaps guessing. (Assumption is mother of all screwups).

It took me 3 clicks and 5 seconds to get to this, http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements2a.htm#SQLRF0021

If OP knew how to get to this... he wouldn't have been scratching his head + he would also get detailed description of each datatype.

Just my 2 cents -:)

Regards
/Rauf Sarwar Received on Tue Jun 10 2003 - 14:49:51 CDT