Technically speaking RAND() is only pseudo-random, thus it is by definition always deterministic.

Now, if the question were "Does the RAND() function create a fixed series of numbers only when a seed parameter is specified" the answer would be yes. However, given the current seed value (the current value within RAND() itself) then RAND() is always deterministic, given that RAND uses an algorithm to calculate the result!

"No" is the truly correct answer, although "depends on definition" obviously is a strong contender. 🙂

I think this question ran aground on the reefs of vagueness...