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

Which optional NPS compatibility features will be activated by executing the following? (Choose two.)
SET SQL_COMPAT="˜NPS'

Answer options

• A. YEARSBETWEEN
• B. BINARY and VARBINARY data types
• C. Double-dot notation to specify a database object
• D. OFFSET x ROWS FETCH FIRST y ROWS ONLY
• E. TRANSLATE (char-string-exp, from-string-exp, to-string-exp)

Correct answer: C, E

Explanation

The correct answers are C and E because enabling NPS compatibility allows the use of double-dot notation for database objects and the TRANSLATE function. The other options, such as YEARSBETWEEN, BINARY and VARBINARY data types, and OFFSET clause, are not specifically related to NPS compatibility features.