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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion