Vidyalelo
MySQL · Q72

MySQL

Programming · MySQL · question 72

Q72

The number of values that can be returned from a given stored function is . . . . . . . .

A.
0
B.
1
Answer
C.
2
D.
3

Answer: Option B

Solution

Answer: Option B
Solution:
0: This option is incorrect. Stored functions in MySQL are designed to return a single value. Therefore, the number of values returned cannot be zero.
1: This is the correct option. Stored functions in MySQL can return exactly one value. This value can be of any supported data type.
2: This option is incorrect. Stored functions in MySQL cannot return multiple values directly. They are limited to returning a single value.
3: This option is incorrect. Stored functions in MySQL cannot return multiple values directly. They are limited to returning a single value.

Therefore, the number of values that can be returned from a given stored function in MySQL is Option B: 1.