DB2 9 Family Fundamentals: C2090-730

Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

A. ""

B. "John Doe"

C. ""

D. ""

Which of the following strings can be inserted into an XML column using XMLPARSE?

A. ""

B. ""

C. ""

D. ""

The following triggers were defined for a table named SALES in the order shown:

CREATE TRIGGER trigger_a NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new FOR EACH ROW SET new.commission = sale_amt * .05 WHERE invoice = n.invoice;

CREATE TRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS WHERE invoice = n.invoice;

CREATE TRIGGER trigger_c NO CASCADE BEFORE DELETE ON sales FOR EACH ROW SIGNAL SQLSTATE '75005' SET MESSAGE_TEXT = 'Deletes not allowed!';

Which of the following statements is NOT true?

A. Once a row has been added to the SALES table, it cannot be removed

B. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column is automatically set to 30 days from today

C. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B

D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations