試題詳解

QUESTION 5 Given a function CALCTAX: long CREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBER IS BEGIN RETURN (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);