Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版) - 1Z0-144日本語 Exam Practice Test
Correct Answer: A
Correct Answer: B,C
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
CREATE OR REPLACE TRIGGER check_price__trg BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price ON product FOR EACH ROW WHEN (nev.prod_id <> NVX(old.prod_id,0) OR New.prod__list_price <> NVL(old.prod_list_price, 0) ) BEGIN check_price (: new.prod_id) ; END /
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
Correct Answer: A
Correct Answer: C
Correct Answer: A,E
Correct Answer: B
Correct Answer: C