DB2 10 for z/OS Database Administrator — Question 33

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

Answer options

• A. XML
• B. REAL
• C. NUMBER
• D. VRCHAR2
• E. VARBINARY

Correct answer: C, E

Explanation

The correct answers are C and E because the NUMBER data type is specifically supported under the Oracle compatibility settings in DB2, and VARBINARY is also valid in this context. The other options, such as XML, REAL, and VRCHAR2, do not have compatibility limited to the Oracle setting.