IBM C2090-616 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-616
Exam Name/Title: DB2 11.1 Fundamentals for LUW
Certification Provider: IBM
Corresponding Certification: IBM Analytics

Exam Questions: 65
Updated On: May 27, 2026

Question #8

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

A. BINARY and VARBINARY data types

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

C. Double-dot notation to specify a database object

D. OFFSET x ROWS FETCH FIRST y ROWS ONLY

E. YEARSBETWEEN

Discussion 0

Correct Answer: B,C Vote an answer

Question #9

What of the following is TRUE about triggers?

A. Only one trigger for a particular event and activation time can be created for a particular table

B. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements

C. Triggers can only be used to execute logic before or after appropriate SQL statements

D. Triggers can be used to perform data manipulation operations against complex views

Discussion 0

Correct Answer: B Vote an answer

Question #10

What is the primary use case for creating an index with the RANDOM option on a table?

A. Maximize performance when inserting into an expression based index containing the RAND() function

B. Minimize contention due to ascending key or descending key inserts, especially in a pureScale environment

C. Maximize performance with OLTP random key queries

D. Minimize hashing skew on a table in a multiple database partition environment, especially with column organized tables

Discussion 0

Correct Answer: B Vote an answer

Question #11

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?

A. DB2 Workgroup Server Edition

B. DB2 Express-C

C. DB2 Enterprise Server Edition

D. DB2 Advanced Enterprise Server Edition

Discussion 0

Correct Answer: D Vote an answer

Question #12

What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

A. 65344 bytes

B. 130688 bytes

C. 32672 bytes

D. 98016 bytes

Discussion 0

Correct Answer: C Vote an answer

Question #13

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

A. Increased throughput of many concurrent short running queries

B. Easy scalability

C. Continuously available dataset solution

D. Management of very large data sets

E. Faster response time of long-running or complex queries with I/O spread across many computers

Discussion 0

Correct Answer: D,E Vote an answer

Question #14

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A. It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

B. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command

C. It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT

D. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM C2090-616 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2090-616 exam.