Based on the code shown, which query lists the complete student table???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)
A) SELECT Student ;
B) SELECT & FROM Student ;
C) SELECT * FROM Student ;
D) SELECT LastName, FirstName, Street, City, State, PostalCode FROM Student

Question

Quizplus · Accepted Answer

Option C is the correct query to list the complete student table because it uses the wildcard character (*) to select all the columns in the table. The other options are incorrect because:
- Option A is invalid syntax as it only specifies the table name without any columns to select.
- Option B is also invalid syntax as the ampersand symbol (&) has no meaning in SQL.
- Option D only selects specific columns in the table, not the entire table.

Based on the Code Shown, Which Query Lists the Complete