問題詳情

QUESTION 64Examine this code:CREATE OR REPLACE PROCEDURE set_bonus(p_cutoff IN VARCHAR2 DEFAULT 'WEEKLY'p_employee_id IN employees_employee_id%TYPEp_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)ISBEGINUPDATE emp_bonusSET 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

參考答案

答案:D
難度:非常困難0
統計:A(0),B(0),C(1),D(0),E(0)