IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 31

Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the
SQL_COMPAT global variable?

Answer options

• A. Implicit casting
• B. Double-dot notation
• C. Use of bitmap indexes
• D. Selecting from the DUAL table

Correct answer: D

Explanation

Selecting from the DUAL table is a compatibility feature that is always available in DB2, independent of other settings. In contrast, implicit casting, double-dot notation, and the use of bitmap indexes can be affected by the configuration of the DB2_COMPATIBILITY_VECTOR and SQL_COMPAT variables.