PrepAway - Latest Free Exam Questions & Answers

Which of the following statements is NOT true?

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?

PrepAway - Latest Free Exam Questions & Answers

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

One Comment on “Which of the following statements is NOT true?


Leave a Reply