Which ALTER TABLE statement will generate a new table space version?
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5)NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
When defining a foreign key on a table, which statement is true?
If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?
On what type of index would an ALTER INDEX ADD COLUMN be allowed?
Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?
