Free IBM C2090-616 Exam Actual Questions

The questions for C2090-616 were last updated On Nov 7, 2024

Question No. 1

Which of the following is TRUE about DB2 OLAP functions?

Show Answer Hide Answer
Correct Answer: C

Question No. 2

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.)

Show Answer Hide Answer
Correct Answer: A, B

Question No. 3

Which of the following authorities is sufficient for connecting to a database?

Show Answer Hide Answer
Correct Answer: B

Question No. 4

Consider the following sequence of events:

Eddie grants SELECT WITH GRANT OPTION privilege to Mike.

Mike grants SELECT privilege to Jeff.

Eddie revokes SELECT privilege from Mike.

What will happen to Jeff's SELECT privilege?

Show Answer Hide Answer
Correct Answer: A

Question No. 5

Which of the following set operators can be used to find all rows that are common in 2 queries?

Show Answer Hide Answer
Correct Answer: D