問題詳情

QUESTION 5Given a function CALCTAX: longCREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBERISBEGINRETURN (sal * 0.05);END;If you want to run the above function from the SQL *Plus prompt, which statement is true?Long
(A)You need to execute the command CALCTAX(1000);.
(B)You need to execute the command EXECUTE FUNCTION calctax;
(C)You need to create a SQL *Plus environment variable X and issue the command :X := CALCTAX(1000);.
(D)You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALCTAX;
(E)You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALCTAX(1000);

參考答案

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