View the Exhibit and examine the structure of the customer table.

Examine the following trigger code:

What is the outcome when the above trigger is compiled?

• A. It gives an error because the statements under updating are not valid.
• B. It compiles successfully.
• C. It gives an error because the new qualifier in the when clause requires a colon prefix.
• D. It gives an error because the when condition is not valid.
• E. It gives an error because when cannot be used for row-level triggers.

View the Exhibit and examine the structure of the EMP table.

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)

• A. Each subprogram's formal parameters should differ in both name and data type.
• B. The procedures should be created only as stand-alone subprograms
• C. The procedures can be either stand-alone or packaged.
• D. The formal parameters of each subprogram should differ in data type but can use the same names.
• E. The procedures should be created only as packaged subprograms

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?

• A. Because the column list specified with UPDATE in the trigger is not valid
• B. Because both the procedure and trigger access the same table
• C. Because the condition specified in the when clause is not valid
• D. Because the procedure call in the trigger is not valid
• E. Because the WHEN clause cannot be used with a row-level trigger

Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply)

• A. It can be the first exception handler.
• B. It can be the only exception handler for the code.
• C. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.
• D. It traps all the exceptions that are not already trapped.