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

What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

Answer options

• A. 32672 bytes
• B. 65344 bytes
• C. 98016 bytes
• D. 130688 bytes A

Correct answer:

Explanation

The correct answer is A. When the VARCHAR2_COMPAT parameter is set to ON, the maximum length for VARCHAR2 is 32672 bytes. The other options exceed this limit and are not valid under this configuration.