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

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.

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



Leave a Reply 0

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