Oracle
1Z0-043 · Question #147
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD.The default format of which two data types would be affected by this setting? (Choose two)
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 in the parameter file to YYYY-MM-DD.The default format of which two data types would be affected by this setting? (Choose two)
Options
- ADATE
- BTIMESTAMP
- CINTERVAL YEAR TO MONTH
- DINTERVAL DAY TO SECOND
- ETIMESTAMP WITH LOCAL TIME ZONE
How the community answered
(45 responses)- A4% (2)
- B76% (34)
- C7% (3)
- D13% (6)
Community Discussion
No community discussion yet for this question.