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