C2090-616 Online Practice Questions and Answers

Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

A. DB2 Connect

B. DB2 Runtime Client

C. DB2 Data Server Client

D. DB2 Enterprise Server Edition

Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

A. COMMIT

B. SAVEPOINT

C. ROLLBACK WORK

D. UPDATE TERMINATE

Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

A. DELETE FROM t1

B. DELETE* FROM t1

C. DELETE* TABLE t1

D. TRUNCATE TABLE t1 IMMEDIATE

E. TRUNCATE TABLE t1

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

Which of the following is fundamental to BLU acceleration?

A. pureScale

B. Column organized tables

C. Multidimensional clustering

D. Purchasing new hardware that is compatible with BLU acceleration and compression

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 of the following features can provide significant benefits in storage savings, performance of analytic workloads, and time to value?

A. pureScale

B. auto reorg

C. BLU acceleration

D. Self tuning memory manager

DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

A. Oracle

B. Sybase

C. Netezza

D. MongoDB

E. Microsoft SQL Server

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

A. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT.

B. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command.

C. 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.

D. 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.

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