試題詳解

QUESTION 43 Examine the trigger: CREATE OR REPLACE TRIGGER Emp_count AFTER DELETE ON Emp_tab FOR EACH ROW DELCARE n INTEGER; BEGIN SELECT COUNT(*) INTO n FROM Emp_tab; DBMS_OUTPUT.PUT_LINE(' There are now ' || a || ' employees,'); END; This trigger results in an error after this SQL statement is entered: DELETE FROM Emp_tab WHERE Empno = 7499; How do you correct the error? long
(A) Change the trigger type to a BEFORE DELET
(E)
(B) Take out the COUNT function because it is not allowed in a trigger.
(C) Remove the DBMS_OUTPUT statement because it is not allowed in a trigger.
(D) Change the trigger to a statement-level trigger by removing FOR EACH ROW.