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
The current user wants to produce a list of all user privileges she has been granted. Which table or

view can be queried to produce the desired result?
Options
A SYSIBMADM.GRANTS
B SYSCAT.DBAUTH
C SYSIBMADM.PRIVILEGES
D SYSCAT.USER_TAB_PRIVS
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
: 40
Options
A UNION ALL
B UNION
C EXCEPT ALL
D INTERSECT ALL Which of the following set operators can be used to find all rows that are common in 2 queries?
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
The creator of an index or an index specification automatically receives which privilege on the index?
Options
A DELETE
B SELECT
C UPDATE
D CONTROL
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
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!

Finish Practice?

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