READ Free Dumps For Oracle- 1z0-144

Question ID 2676	View Exhibit1 and examine the structure of the product table.   View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list price is within a given range.   You then create the following trigger on the product table. 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 / Examine the following update command for an existing row in the product table. SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115; Why does it generate an error?
Option A	A.    Because the procedure call in the trigger is not valid
Option B	B.    Because the condition specified in the when clause is not valid
Option C	C.    Because boththe procedure and trigger access the same table
Option D	D.    Because the WHEN clause cannot be used with a row-level trigger
Option E	E.    Because the column list specified with UPDATE in the trigger is not valid
Correct Answer	B

Explanation

Question ID 2677	Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.)
Option A	A.    Add exception handlers whenever errors occur.
Option B	B.    An exception handler should commit the transaction.
Option C	C.    Handle named exceptions whenever possible instead of using when others in exception   handlers.
Option D	D. Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur.
Correct Answer	C,D

Explanation

Previous-Page 1 2. . . 21 22 23 24 25 26 27. . . 62 63 Next-Page

Send email to admin@getfreedumps for new dumps request!!!