Oracle
1Z0-882 · Question #13
Consider the CREATE FUNCTION statement: CREATE FUNCTION countrycount () BEGIN DECLARE count INT; SELECT COUNT (*) INTO count FROM country; RETURN count ; END What is the outcome when you try to…
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Stored Programs
Question
Consider the CREATE FUNCTION statement:
CREATE FUNCTION countrycount () BEGIN DECLARE count INT; SELECT COUNT (*) INTO count FROM country; RETURN count ; END What is the outcome when you try to create the function?
Options
- AAn error results as the SELECT must assign the return values to a user variable.
- BAn error results as the count variable is not initialized with a value.
- CAn error result as the function must be defined with the CONTAINS SQL clause.
- DAn error result as the variable type returned by the function must be defined with a RETURNS
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.
Topics
#stored functions#RETURNS clause#function definition#CREATE FUNCTION syntax