Question

To produce a stored function, which statement is used?

(a) PRODUCE FUNCTION

(b) CREATE FUNCTION

(c) PRODUCE PROCEDURE

(d) CREATE PROCEDURE

The question was asked in an interview for job.

I want to ask this question from Stored Functions and Procedures in chapter Stored Programs of MySQL

Answer 1

Right option is (b) CREATE FUNCTION

The best explanation: The ‘CREATE FUNCTION’ statement is used to create a stored function in MySQL. The ‘CREATE PROCEDURE’ statement is used to create a stored procedure instead, from which values are not returned.