Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)

The correct answer is A. TIMESTAMP C. INTERVAL DAY TO SECOND D. INTERVAL YEAR TO MONTH. TIMESTAMP, INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH can be used to specify column definition. Incorrect Answers B: The INTERVAL MONTH TO DAY data type cannot be used when specifying column definitions there are only INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH…

Creating and Managing Schema Objects

Question

Options

ATIMESTAMP
BINTERVAL MONTH TO DAY
CINTERVAL DAY TO SECOND
DINTERVAL YEAR TO MONTH
ETIMESTAMP WITH DATABASE TIMEZONE

How the community answered

(33 responses)

A
82% (27)
B
12% (4)
E
6% (2)

Explanation

TIMESTAMP, INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH can be used to specify column definition. Incorrect Answers B: The INTERVAL MONTH TO DAY data type cannot be used when specifying column definitions there are only INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH data E: The TIMESTAMP WITH DATABASE TIMEZONE data type cannot be used when specifying column definitions, because there are only TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types.

Topics

#DATETIME data types#TIMESTAMP#INTERVAL types#Oracle date types

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice