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 San Francisco user selects the row, booking_date is displayed as 007-05-10
3.00.00.000000 -8:00′
B.
When the San Francisco user selects the row, booking_date is displayed as 007-05-10
3.00.00.000000′
C.
When the New York user selects the row, booking_date is displayed as 007-05-10
3.00.00.000000′
D.
When the New York user selects the row, booking_date is displayed as 2007-05-10
6.00.00.000000 -5:00′.