Application B will read the row.

Applications A and B will cause a deadlock situation.

Application B will wait until application A releases the Update lock.

Application A will be terminated so that application B can read the row.

Foreign key references cannot cross schema boundaries.

A DB2 user must be created before a schema with the same name can be created.

If no schema is specified when an object is created, the default schema PUBLIC is used.

A schema enables the creation of multiple objects in a database without encountering namespace collisions.

The cursor is only protected from updates and deletes by concurrent applications.

The row is only protected from positioned updates and deletes that reference another cursor of the same application.

The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

DB2 for i5/OS

DB2 Runtime Client

DB2 Connect Enterprise Edition

DB2 for i5/OS SQL Development Kit

A sequence will never generate duplicate values

The MAXVALUE of a sequence can be equal to the MINVALUE

It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero

When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

DB2 Express Edition

DB2 Personal Edition

DB2 Workgroup Server Edition

DB2 Enterprise Server Edition

SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4

SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4

SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4

SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4

Locks are acquired on the data.

Locks are acquired on index keys.

Locks are acquired on index pages.

Locks are acquired on index pointers.

0

1

2

3