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

Which of the following is TRUE regarding user switching in a trusted context?

A. You cannot switch user id in a trusted context.

B. You can issue a switch-user request within a transaction.

C. The new user must have the connect-privilege on the database for it to succeed.

D. No password is ever required for the new user as an authentication is established in the trusted connection.

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.

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

A. Temp1 table is accessed under schema SESSION

B. Temp1 definition is available for use by other sessions

C. At the end of a transaction, data is deleted automatically

D. Definition of the table Temp1 is stored in database catalog

E. Rows inserted by one session are visible in other sessions