Assume the following table named Student exists in a database:

Which of the following SQL statements will return only the student name and GPA from the Student table for all students having a GPA that is greater than or equal to 3.5?
A) SELECT Name, GPA FROM Student WHERE GPA =3.5
B) SELECT * FROM Student WHERE GPA = 3.5
C) SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA = 3.5
D) SELECT Student WHERE GPA = 3.5 And Name, GPA

Question

Assume the following table named Student exists in a database:

Which of the following SQL statements will return only the student name and GPA from the Student table for all students having a GPA that is greater than or equal to 3.5?
A) SELECT Name, GPA FROM Student WHERE GPA >=3.5 
B) SELECT * FROM Student WHERE GPA >= 3.5 
C) SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA >= 3.5 
D) SELECT Student WHERE GPA >= 3.5 And Name, GPA

Quizplus · Accepted Answer

This choice selects only the necessary columns (Name and GPA) and filters the rows with a condition on the GPA column. Option B selects all columns, which is not necessary for the given question. Option C selects additional columns (Number and CumHrs) which are not required. Option D has a syntax error in the SELECT clause, where both the column names and table names are used together.

Assume the Following Table Named Student Exists in a Database