Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)
When DB2_COMPATIBILITY_VECTOR is set to ORA, it indicates that the DB2 database is in compatibility mode to support Oracle-specific features. Among the provided options, the data types NUMBER and VARCHAR2 specifically align with Oracle databases. Therefore, these data types are only valid under this compatibility setting.
The correct answers are NUMBER and VARCHAR2 (or NVARCHAR2). Reference : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.porting.doc/com.ibm.db2.luw.apdv.porting.doc-gentopic1.html