Exit C2090-616 DB2 11.1 Fundamentals for LUW
Question 1 of 5
0% complete
Q1 Multiple choice

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

SET SQL_COMPAT=`NPS'

Select all that apply.

  • A

    YEARSBETWEEN

  • B

    BINARY and VARBINARY data types

  • C

    Double-dot notation to specify a database object

  • D

    OFFSET x ROWS FETCH FIRST y ROWS ONLY

  • E

    TRANSLATE (char-string-exp, from-string-exp, to-string-exp)

Previous Next