Multiple choice technology databases

What will be the output of the query select * from table1 order by rand()

  1. Error

  2. All columns ordered randomly

  3. rows picked in a random way

  4. None of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ORDER BY RAND() randomizes the sequence of rows returned by the query. Each execution returns rows in a different random order. Option C correctly describes this behavior. Option B is incorrect because it's the rows that are randomized, not individual columns.