Multiple choice technology databases

Deterministic functions are?

  1. Functions always return the same result any time they are called with a specific set of input values.

  2. Functions may return different results each time they are called with a specific set of input values

  3. None

  4. Both of Them
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Deterministic functions always return the identical result given the same set of input values and database state. Non-deterministic functions (like GETDATE() or RAND()) can return different values on subsequent invocations with the same parameters.

Keep practicing — related questions