Oracle
1Z0-034 · Question #95
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
The correct answer is B. TIMESTAMP E. TIMESTAMP WITH LOCAL TIME ZONE. See the full explanation below for the reasoning.
Question
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
Options
- ADATE
- BTIMESTAMP
- CINTERVAL YEAR TO MONTH
- DINTERVAL DAY TO SECOND
- ETIMESTAMP WITH LOCAL TIME ZONE
How the community answered
(24 responses)- A4% (1)
- B83% (20)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.