IBM C2090-320 DB2 11 Fundamentals for z/OS Exam Practice Test

Given the following sequence of events:

1) COL1 in SCHEMA.TABLE has a value of 10

2) Update COL1 in SCHEMA.TABLE to 20 3)SetSAVEPOINTA

4) Update COL1 in SCHEMA.TABLE to 30 5)SetSAVEPOINTB

After issuing the statement:

ROLLBACK TO SAVEPOINT

What will be the value in COL1 of the SCHEMA.TABLE?

When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

Which type of lock is obtained when using a 'WITH UR1 clause on an SQL SELECT statement in a data-sharing environment?

How can a user-defined function (UDF) be invoked?

You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

How can a stored procedure be invoked?

In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)