Re: OCP Question: Oracle 9i introduction

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 ....

Cheers

Richard

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA703C4C5C3_at_lnewton.leeds.lfs.co.uk...
> And so is
>
> B. Interval Day to Second.
>
> Once again, OCP question ambiguity strikes !!!
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
> -----Original Message-----
> From: Norman Dunbar
> Posted At: Tuesday, June 10, 2003 12:00 PM
> Posted To: misc
> Conversation: OCP Question: Oracle 9i introduction
> Subject: OCP Question: Oracle 9i introduction
>
>
> Hi Willie,
>
> D. Interval Year to Month is also correct.
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
> -----Original Message-----
> From: w2jin_at_hotmail.com (willie) [mailto:w2jin_at_hotmail.com]
> Posted At: Monday, June 09, 2003 9:31 PM
> Posted To: misc
> Conversation: OCP Question: Oracle 9i introduction
> Subject: OCP Question: Oracle 9i introduction
>
>
> Hi, All:
>
> The following question is from OCP exam, I do not know the exactlly
> answer. Any help will be appreciated.
>
> Question: Which of data type is valid when you create table? (chose
> three answers)
>
> A. Timestamp
> B. Interval day to second
> C. Interval month to day
> D. Interval year to month
> E. Tomestamp with database timezone.
>
> I know A and E are correct, but which is the third one?
>
> Thanks
> Willie
>
Received on Tue Jun 10 2003 - 07:56:08 CDT