Examveda

For the same input parameters, if the stored function returns the same result, it is called . . . . . . . .

A. deterministic

B. non deterministic

C. regular

D. monotonous

Answer: Option A

Solution (By Examveda Team)

Imagine you have a special calculator called a "stored function" in your MySQL database. This calculator does some calculations based on numbers you give it (input parameters).
Let's say you input the same numbers into the calculator twice. If the calculator always gives you the *same* answer both times, it's called deterministic. It's predictable and reliable.
So the correct answer is Option A: deterministic.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous