Oracle
1Z0-147 · Question #25
1Z0-147 Question #25: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
Question
Given a function CALCTAX:
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?
Options
- AYou need to execute the command CALCTAX(1000); .
- BYou need to execute the command EXECUTE FUNCTION calctax; .
- CYou need to create a SQL*Plus environment variable X and issue the command X := CALCTAX(1000); .
- DYou need to create a SQL*Plus environment variable X and issue the command EXECUTE :X := CALCTAX; .
- EYou need to create a SQL*Plus environment variable X and issue the command EXECUTE :X := CALCTAX(1000); .
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.