Beginner
Database Management Systems
Q5 / 100
What does SELECT * FROM users do?
Correct! Well done.
Incorrect.
The correct answer is C) Retrieves all columns and all rows from the users table
C
Correct Answer
Retrieves all columns and all rows from the users table
Explanation
SELECT * retrieves all columns. FROM users specifies the table. Adding WHERE, ORDER BY, LIMIT refines the result set. SELECT * is avoided in production due to performance and coupling concerns.
Progress
5/100