047-267

267. 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. 1d,2c,3a,4b

B. 1b,2a,3c,4d

C. 1b,2a,3d,4c

D. 1d,2c,3b,4a

Answer: A

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-719017/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-719017/