試題詳解

QUESTION 64 Examine this code: CREATE OR REPLACE PROCEDURE set_bonus (p_cutoff IN VARCHAR2 DEFAULT 'WEEKLY' p_employee_id IN employees_employee_id%TYPE p_salary IN employees_salary%TYPE, p_bonus_percent IN OUT NUMBER DEFAULT 1.5, p_margin OUT NUMBER DEFAULT 2, p_bonus_value OUT NUMBER) IS BEGIN UPDATE emp_bonus SET bonus_amount =(p_salary * p_bonus_percent)/p_margin WHERE employee_id = p_employee_id; END set_bonus; / You execute the CREATE PROCEDURE statement above and notice that it fails. What are two reasons why it fails? (Choose two) Is d~~ 1. The syntax of the UPDATE statement is incorrect. 2. You cannot update a table using a stored procedure. 3. The format parameter p_bonus_value is declared but is not used anywhere. 4. The formal parameter p_cutoff cannot have a DEFAULT clause. 5. The declaration of the format parameter p_margin cannot have a DEFAULT clause. 6. The declaration of the format parameter p_bonus_percent cannot have a DEFAULT clause.
(A)12
(B)23
(C)34
(D)56