Oracle Database 12c: Advanced Administration — Question 181

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?

Answer options

• A. DATE
• B. TIMESTAMP
• C. INTERVAL YEAR TO MONTH
• D. INTERVAL DAY TO SECOND
• E. TIMESTAMP WITH LOCAL TIME ZONE

Correct answer: B, E

Explanation

The NLS_TIMESTAMP_TZ_FORMAT parameter specifically affects the formatting of TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE data types. The DATE type has its own formatting rules that are not influenced by this parameter, and INTERVAL types are not impacted by timestamp format settings.