Identify the option that correctly matches the data types with the values.

Prev Question
Next 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) ‘+06 03:30:16.000000′
3)TIMESTAMP WITH TIME ZONE c) ’17-JUN-03 12.00.00.000000 AM’
4)INTERVAL DAY TO SECOND d) ‘+02-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

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *