Given the following requirements:
Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the
identity column to generate the values for the column by default. Start the values at 10 and
increment by 10. Make the identity column unique.
Which of the following CREATE statements will successfully create this table?

Which of the following can be used to ensure that once a row has been inserted in table TABLEX,
the column MAINID in that row cannot be updated?

Which of the following supports the XML data type?

A trigger can be created on which of the following objects?

Which of the following is a valid DB2 data type?

Which of the following DB2 data types can be used to store 1000 MB of single-byte character
data?

Which of the following DB2 data types CANNOT be used to create an identity column?

Given the requirements to store employee names, employee numbers, and when employees were
hired, which of the following built-in data types CANNOT be used to store the day an employee
was hired?

Given the requirements to store customer names, billing addresses, and telephone numbers,
which of the following would be the best way to define the telephone number column for a table if
all customers were located in the same country?

Which of the following is a NOT a valid reason for defining a view on a table?