Question: To select a random student from the table, which statement could you use?
- `SELECT TOP(1) first_name, last_name FROM Students ORDER BY NEWID();`
- `SELECT TOP(1) RAND(first_name, last_name) FROM Student;`
- `SELECT TOP(1) first_name, last_name FROM Student;`
- `SELECT TOP(1) first_name, last_name FROM RAND(Student);`
Answer: The correct answer of the above question is Option A:`SELECT TOP(1) first_name, last_name FROM Students ORDER BY NEWID();`