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

In SQL databases like MySQL, ORDER BY rand() assigns a random value to each row and sorts the rows based on these values, resulting in the rows being returned in a random order.