Oracle
1Z0-047 · Question #179
Given below is a list of datetime data types and examples of values stored in them in a random order: Datatype Example 1) INTERVAL YEAR TO MONTH a) 2003-04-15 8:00:00 -8:00' 2) TIMESTAMP WITH LOCAL…
The correct answer is A. 1-d, 2-c, 3-a, 4-b. See the full explanation below for the reasoning.
Question
Given below is a list of datetime data types and examples of values stored in them in a random order: Datatype Example 1) INTERVAL YEAR TO MONTH a) 2003-04-15 8:00:00 -8:00' 2) TIMESTAMP WITH LOCAL TIME ZONE b) '-K)6 03:30:16.000000' 3) TIMESTAMP WITH TIME ZONE c) '17-JUN-03 12.00.00.000000 AM' 4) INTERVAL DAY TO SECOND d) '402-00' Identify the option that correctly matches the data types with the values.
Options
- A1-d, 2-c, 3-a, 4-b
- B1-b, 2-a, 3-c, 4-d
- C1-b, 2-a, 3-d, 4-c
- D1-d, 2-c, 3-b, 4-a
How the community answered
(29 responses)- A83% (24)
- B3% (1)
- C10% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.