Free IBM C2090-616 Exam Actual Questions

The questions for C2090-616 were last updated On May 2, 2024

Question No. 1

You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?

Which of the following editions would be best meet the described needs?

Show Answer Hide Answer
Correct Answer: D

Question No. 2

Which of the following editions of DB2 include support for Federation with Oracle database?

Show Answer Hide Answer
Correct Answer: C

Question No. 3

Which three facilities are used to control authorization in DB2?

Show Answer Hide Answer
Correct Answer: D

Question No. 4

Which database object can be locked explicitly?

Show Answer Hide Answer
Correct Answer: D

Question No. 5

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?

REVOKE SELECT ON TABLE mytable FROM USER myuser

Show Answer Hide Answer
Correct Answer: C