Multiple choice technology databases

Which one of the below functions is Non-Deterministic?

  1. CASE

  2. ISNULL

  3. ISNUMERIC

  4. ISDATE

  5. None
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A deterministic function always returns the same result for the same input. Non-deterministic functions can return different results. ISDATE is non-deterministic because its behavior depends on session settings like DATEFORMAT and LANGUAGE - the same string might be interpreted differently. CASE, ISNULL, and ISNUMERIC are deterministic functions.

Keep practicing — related questions