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?

Question

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?

Accepted Answer

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

Answer

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

Answer

B. When the New York user selects the row, booking_date is displayed as '2007-05-10 6.00.00.000000

Answer

D. When the San Francisco user selects the row, booking_date is displayed as '007-05-10 3.00.00.000000 -

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…

Question

Options

How the community answered

Community Discussion