The alias A1 will be dropped

The table T1 will be dropped

Both T1 and A1 will be dropped

Nothing, the statement will result in an error

NOT NULL

Foreign key

Primary key

Informational constraint

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

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

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

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

Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

DB2 Developer Edition

DB2 Express Server Edition

DB2 Enterprise Server Edition

DB2 Connect Enterprise Server Edition