DB2 11.1 Fundamentals for LUW

Here you have the best IBM C2090-616 practice exam questions

  • You have 63 total questions across 13 pages (5 per page)
  • These questions were last updated on February 16, 2026
  • This site is not affiliated with or endorsed by IBM.
Question 1 of 63
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?
Answer

Suggested Answer

Given the requirements of handling long, complex queries, significant data size, and the need for optimized storage on disk, DB2 Advanced Enterprise Server Edition is the best choice. This edition includes advanced features such as BLU Acceleration, which is specifically designed to efficiently execute complex queries with groupings and aggregations by using columnar storage and in-memory processing. Additionally, it does not have the resource limitations that other editions such as Express-C or Workgroup Server Edition might have, ensuring the system can handle the size and expected growth of the database.

Community Votes

No votes yet

Join the discussion to cast yours

Question 2 of 63
Which of the following editions of DB2 include support for Federation with Oracle database?
Answer

Suggested Answer

The suggested answer is B.

The DB2 Developer Edition includes support for Federation with Oracle database. This edition is designed for development and thus includes comprehensive functionality, including features for database federation, which allows integrating data across multiple databases including Oracle.

Community Votes

No votes yet

Join the discussion to cast yours

Question 3 of 63
Which three facilities are used to control authorization in DB2?
Answer

Suggested Answer

The suggested answer is D.

In DB2, authorization is controlled using privileges, authority levels, and Label-Based Access Control (LBAC) credentials. Privileges determine what actions users can perform, authority levels provide hierarchical administrative controls, and LBAC credentials provide fine-grained access control to data.

Community Votes

No votes yet

Join the discussion to cast yours

Question 4 of 63
Which database object can be locked explicitly?
Answer

Suggested Answer

The suggested answer is D.

A table is a database object that can be explicitly locked. This is done using commands such as LOCK TABLE ... IN EXCLUSIVE MODE or LOCK TABLE ... IN SHARE MODE, which allow for specific control over how the table is accessed by different transactions. Rows, views, and indexes do not support explicit locking in the same way tables do.

Community Votes

No votes yet

Join the discussion to cast yours

Question 5 of 63
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
Answer

Suggested Answer

Community Votes

No votes yet

Join the discussion to cast yours

About the IBM C2090-616 Certification Exam

About the Exam

The IBM C2090-616 (DB2 11.1 Fundamentals for LUW) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 63 practice questions across 13 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our C2090-616 questions are regularly updated to reflect the latest exam objectives.