Logo ExamsQA
Exit
Official Bank 0/63

DB2 11.1 Fundamentals for LUW (C2090-616) - IBM Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
63 Total Questions
1
Question
What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC
RETURN SIN(X)/COS(X)
Options
A Table
B Row
C External
D Scalar
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?
Options
A Double-dot notation
B Implicit casting
C Use of bitmap indexes
D Selecting from the DUAL table
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
Which method for restricting data access relies on security labels and security policies to control

what data a user can access?
Options
A Authorities and privileges
B Authentication
C Row and column access control
D Label-based access control
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?
Options
A DB2 Runtime Client
B DB2 Connect
C DB2 Data Server Client
D DB2 Enterprise Server Edition
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?
Options
A UPDATE t1 SET c1 = ‘DB2, c2’ = 11
B UPDATE t1 c1 = ‘DB2, c2’ = 11
C UPDATE t1 c1 = ‘DB2’, c2 = 11 WHERE c3 = 2016
D UPDATE t1 SET (c1, c2) = (‘DB2’, 11) = WHERE c3 = 2016
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.