Which statement about BEFORE triggers is FALSE?

An existing non-automatic storage database named MYDB has been successfully converted to an automatic
storage database. What must be done to convert any existing DMS table spaces to automatic storage table
spaces?

A partitioned table named SALES was created as follows:

Which statement about the PARTS_IDX index is true?

Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a
compression dictionary for a table? (Choose two.)

Given a system-period temporal table POLICY_INFO with its associated history table HIST_POLICY_INFO,
which statement is true?

Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications
and a DB2 server?

Which statement about Binary XML is FALSE?

Which statement about the ADMIN_MOVE_TABLE procedure is true?

Table TAB1 was created as follows:

Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for
compression?

If an MQT named Q1_SALES was created as follows:

Which statement will execute successfully?