Which statement is TRUE regarding ROLLBACK processing?
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with "CREATE INDEX AAA ON"¦". Which of the following statements must precede the CREATE statement so that you can create the index?
The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?
In a unique referential constraint, which type of key does a foreign key reference?
Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
