Which edition of DB2 LUW has been discontinued in v11.1?

A. DB2 Developer Edition

B. DB2 Express Server Edition

C. DB2 Enterprise Server Edition

D. DB2 Connect Enterprise Server Edition

Which database object can be locked explicitly?

A. Row

B. View

C. Index

D. Table

Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

A. Read Stability

B. Cursor Stability

C. Repeatable Read

D. Cursor Stability with WAIT FOR OUTCOME clause

Application 1 executes the following statements:

INSERT INTO TAB1 (NAME,AMOUNT) VALUES (`John,100);

COMMIT;

UPDATE TAB1 SET AMOUNT=90 WHERE NAME=`John';

After a few seconds, application 2 executes the following query:

SELECT AMOUNT FROM TAB1 WHERE NAME=`John'

Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the

following is TRUE?

A. Application 2 will read the amount of 90

B. Application 2 will read the amount of 100

C. Application 2 will receive a warning message

D. Application 2 will enter lock-wait state until application 1 commits or the locktimeout value expires

Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

A. Deadlock

B. Lock timeout

C. Lock escalation

D. Lock conversion

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'

A.

B. 0

C. 1

D. 3

E. 5

Which method for restricting data access relies on security labels and security policies to control what data a user can access?

A. Authentication

B. Authorities and privileges

C. Label-based access control

D. Row and column access control

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

A. YEARSBETWEEN

B. BINARY and VARBINARY data types

C. Double-dot notation to specify a database object

D. OFFSET x ROWS FETCH FIRST y ROWS ONLY

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

Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?

A. View

B. Alias

C. Table

D. Schema

Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?

A. UPDATE t1 c1 = `DB2, c2' = 11

B. UPDATE t1 SET 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