Based on the code shown, which query finds the name of the student whose ID is 1167???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)
A) SELECT FirstName, LastName FROM Course WHERE StudentID='1167' ;
B) SELECT FirstName, LastName FROM * WHERE StudentID='1167' ;
C) SELECT FirstName, LastName FROM Student WHERE StudentID='1167' ;
D) SELECT FirstName, LastName FROM Customer WHERE StudentID='1167' ;

Question

Quizplus · Accepted Answer

The query needs to be performed on the "Student" table, which contains the columns "StudentID", "FirstName", and "LastName". Option A queries on a "Course" table which may not contain the required information, and Option B uses an asterisk, which is not necessary and can lead to errors. Option D queries on a "Customer" table, which is not relevant to the given requirement.

Based on the Code Shown, Which Query Finds the Name