Question

How many values can be returned from a given stored function?

(a) 0

(b) 1

(c) 2

(d) 3

This question was posed to me by my college professor while I was bunking the class.

Asked question is from Stored Functions and Procedures topic in chapter Stored Programs of MySQL

Answer 1

The correct answer is (b) 1

The best explanation: In MySQL, the stored function cannot return multiple values. Instead, multiple stored functions can be written and invoked from within a single statement however, they are different from stored procedures.