DB2 11.1 Fundamentals for LUW (C2090-616) - IBM Actual Exam Questions
Last updated on April 25, 2026
Consider the following query and the resulting set of data: SELECT empno, lastname FROM emp WHERE empno BETWEEN ‘000020’ and ‘000070’ Result: If the query below is executed, how many rows will be returned? SELECT empno FROM emp WHERE empno > ‘000020’ AND empno ‘000070’
0
1
3
5
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Given the following statement: DECLARE GLOBAL TEMPORARY TABLE TEMP1 ( ID INTEGER NOT NULL, ITEM CHAR(30), AMOUNT DECIMAL (10,2) ON COMMIT DELETE ROWS NOT LOGGED; Which of the following statements are TRUE? (Choose two.)
Temp1 table is accessed under schema SESSION
Temp1 definition is available for use by other sessions
At the end of a transaction, data is deleted automatically
Definition of the table Temp1 is stored in database catalog
Rows inserted by one session are visible in other sessions
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following statements regarding locking is TRUE?
The same lock modes apply to tables, rows, or blocks
Lock conversion can take place implicitly as a query executes
Changing the mode of a lock that is already held is called lock escalation
Lock conversion is not necessary if an X lock is required and an S or U lock is currently held
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?
Cloudant
DB2 on Cloud
dashDB for analytics
dashDB for transactions
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which edition of DB2 LUW has been discontinued in v11.1?
DB2 Developer Edition
DB2 Express Server Edition
DB2 Enterprise Server Edition
DB2 Connect Enterprise Server Edition
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.