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
Which of the following authorities is sufficient for connecting to a database?
Options
A CONNECT
B SQLADM
C DATAACESS
D ACCESSCTRL
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
Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?
Options
A Alias
B View
C Table
D Schema
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

Finish Practice?

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