C2090-616 Exam Training Practice Tests (IBM DB2 11.1 Fundamentals for LUW)]

Question 1

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A. It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed B. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT C. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command D. It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT

Correct Answer: A

Question 2

Which of the following statements will successfully create a table that scores index data in a different table space than the table data?

A. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1; B. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2; C. CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2; D. CREATE TABLE t1 (c1 INT, c2 INT);

Correct Answer: B

Question 3

If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

A. Lock escalation will be prevented B. Query performance will be reduced C. Concurrency may be improved D. The number of locks for the same workload will be reduced

Correct Answer: C

Question 4

Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

A. Cursor Stability B. Repeatable Read C. Read Stability D. Uncommitted Read

Correct Answer: B

Question 5

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

A. Only uncommitted read (UR) applications can access the table B. No other applications can access the table C. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped D. The lock owner can both read and update datA. Other applications can read the table E. The lock owner and other applications can read, but not update, the locked table

Correct Answer: B,C

Question 6

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

A. Row and column access control B. Authentication C. Label-based access control D. Authorities and privileges

Correct Answer: C

Question 7

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 c1 = 'DB2', c2 = 11 WHERE c3 = 2016 C. UPDATE t1 SET (c1, c2) = ('DB2', 11) = WHERE c3 = 2016 D. UPDATE t1 SET c1 = 'DB2, c2' = 11

Correct Answer: B

IBM DB2 11.1 Fundamentals for LUW - C2090-616 Exam Practice Test