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?

If the following SQL statements are executed:
CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,
name VARCHAR(25));
CREATE TABLE tab2 (empid SMALLINT,
weekno SMALLINT,
payamt DECIMAL(6,2),
CONSTRAINT const1 FOREIGN KEY (empid)
REFERENCES taba(id) ON UPDATE NO ACTION);
Which of the following statements is true?

An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be
specified for the column that will be used for storing the image?