Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Ibm Discussions
exam questions

Exam C2090-616 All Questions

View all questions & answers for the C2090-616 exam
Go to Exam

Exam C2090-616 topic 1 question 39 discussion

Actual exam question from IBM's C2090-616
Question #: 39
Topic #: 1
[All C2090-616 Questions]

Which optional NPS compatibility features will be activated by executing the following? (Choose two.)
SET SQL_COMPAT="˜NPS'

  • 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)
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
Reference: https://www.google.com/url?
sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=2ahUKEwiWvqq07PncAhVIqxoKHVZdCqAQFjABegQICRAC&url=https%3A%2F%
2Fwww.ibm.com%2Fdeveloperworks%2Fcommunity%2Ffiles%2Fform%2Fanonymous%2Fapi%2Flibrary%2F89c92396-429f-440a-a682-b0139921a14f%
2Fdocument%2Fd01b0ccd-cbd9-43f8-9347-033750ea533c%2Fmedia%2FSTLDUG1606-LUW-3-DB2%252011.1%2520LUW%2520Overview-
Cialini.pdf&usg=AOvVaw1G55BpetB6pwzWNYZMgOqO
by db2tester at Oct. 16, 2019, 10:19 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
JamesBond
3 years, 4 months ago
Answer is correct https://www.ibm.com/docs/en/db2woc?topic=compatibility-features-netezza-platform-software-nps
upvoted 1 times
...
db2tester
5 years, 1 month ago
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
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel