Exam C2090-616 All QuestionsBrowse all questions from this exam
Question 30

DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

    Correct Answer: A, B

    DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with Oracle and Sybase. These variables allow DB2 to support functionalities and behaviors that are specific to these databases, making it easier for applications designed for Oracle and Sybase to function correctly within a DB2 environment.

Discussion
db2testerOptions: AB

The question is ambigous ! Oracle, Sybase and MySQL are supported with the registry variable DB2_COMPATIBILITY_VECTOR. Nettezza is also supported with the global variable SQL_COMPAT (NPS). The answer C is also correct.