Examveda

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

A. 0

B. 1

C. 2

D. 3

Answer: Option B

Solution (By Examveda Team)

This question asks about stored functions in MySQL. A stored function is like a mini-program that you can use over and over again.

Imagine you have a recipe for a cake. You can use that recipe (stored function) to bake many cakes.

Now, think about what the cake recipe does. It tells you how to combine ingredients and bake a cake. In the end, you get one cake (one value).

The same goes for stored functions in MySQL. They can do some calculations or actions, but they can only return one value at a time.

So the answer is Option B: 1.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous