What is an informational constraint?

You want to modify an existing view so that any rows that are inserted or updated with the view will not violate
the SELECT statement that was used to create the view. What should you do?

What are two purposes of the SET INTEGRITY statement? (Choose two.)

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?