Which statement is true?

Evaluate the SQL statements:
CREATE TABLE new_order
(orderno NUMBER(4),
booking_date TIMESTAMP WITH LOCAL TIME ZONE);
The database is located in San Francisco where the time zone is -8:00. The user is located in New York where the time zone is -5:00.
A New York user inserts the following record:
INSERT INTO new_order
VALUES(1, TIMESTAMP ?007-05-10 6:00:00 -5:00?);
Which statement is true?

Evaluate the SQL statements:
CREATE TABLE new_order
(orderno NUMBER(4),
booking_date TIMESTAMP WITH LOCAL TIME ZONE);
The database is located in San Francisco where the time zone is -8:00. The user is located in New York where the time zone is -5:00.
A New York user inserts the following record:
INSERT INTO new_order
VALUES(1, TIMESTAMP ?007-05-10 6:00:00 -5:00?);
Which statement is true?

A.
When the New York user selects the row, booking_date is displayed as ‘007-05-10 3.00.00.000000’

B.
When the New York user selects the row, booking_date is displayed as ‘2007-05-10 6.00.00.000000 – 5:00’.

C.
When the San Francisco user selects the row, booking_date is displayed as ‘007-05-10 3.00.00.000000’

D.
When the San Francisco user selects the row, booking_date is displayed as ‘007-05-10 3.00.00.000000 -8:00’



Leave a Reply 5

Your email address will not be published. Required fields are marked *


miriam

miriam

why is answer C?

xxx

xxx

Because timestamp with local time zone doesnt show zone difference (-5:00 or -8:00) during query.

kwck

kwck

Clause VALUES in the INSERT statement is incorrect. Timestamp with -5.00 value gives error.

mr_tienvu

mr_tienvu

I choose