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.
A. 1-d.2-c.3-a.4-b
B. 1-b.2-a.3-c.4-d
C. 1-b.2-a, 3-d, 4-c
D. 1-d.2-c.3-b.4-a
|
Download Printable PDF. VALID exam to help you PASS. |
 |