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

Which optional NPS compatibility features will be activated by executing the following? (Choose two.)

SET SQL_COMPAT="˜NPS'

    Correct Answer: C, E

    The optional NPS (Netezza Performance Server) compatibility features activated by setting SQL_COMPAT='NPS' include the Double-dot notation to specify a database object and the TRANSLATE (char-string-exp, from-string-exp, to-string-exp) scalar function syntax. These features align with the NPS SQL syntax, enabling easier migration and compatibility for SQL scripts and queries.

Discussion
JamesBond

Answer is correct https://www.ibm.com/docs/en/db2woc?topic=compatibility-features-netezza-platform-software-nps

db2testerOptions: CE

Some NPS compatibility features (such as equivalent data type names and the DATASLICEID pseudocolumn) are always active; others are active only if the SQL_COMPAT global variable is set to 'NPS'. - Data type aliases - DATASLICEID pseudocolumn - Routines written in NZPLSQL - Double-dot notation -TRANSLATE scalar function syntax - Operators - Grouping by SELECT clause columns - Expressions refer to column aliases https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.porting.doc/doc/c_compat_nz.html