Oracle
1Z0-047 · Question #100
1Z0-047 Question #100: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #100. The question stem and answer options stay visible for context.
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?
Options
- AWhen the New York user selects the row, booking_date is displayed as '007-05-10 3.00.00.000000'
- BWhen the New York user selects the row, booking_date is displayed as '2007-05-10 6.00.00.000000
- CWhen the San Francisco user selects the row, booking_date is displayed as '007-05-10 3.00.00.000000'
- DWhen the San Francisco user selects the row, booking_date is displayed as '007-05-10 3.00.00.000000 -
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.