New Features for Administrators - Question 046

Examine the list of variables and their data types:

Name Data Type

TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS INTERVAL DAY TO SECOND

Which three expressions using the new date and time data types are valid? (Choose three.)

A. IDS* 2

B. TS + IYM

C. TS -TS1

D. IDS - TS

E. IDS + IYM

Answer: A, B, E

Explanation:

IDS*2, TS+IYM and IDS+IYM are valid new date and time data types.

Incorrect Answers

C: You cannot subtract timestamps.

D: It’s not possible to subtract timestamp from the interval day to second.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 266-271

Chapter 5: Language Enhancements

Oracle 9i New Features, Robert Freeman, p. 132-135

Chapter 5: Miscellaneous Oracle9i Features and Enhancements