The tblStudent table contains nine fields, one of which is the StudentID field. A user can type in any StudentID to select a particular student. Which of the following statements would allow the user to select the data for any StudentID number?

A. SELECT * FROM tblStudentWHERE StudentID = StudentID
B. SELECT * FROM tblStudentIF StudentID = @StudentID
C. SELECT * FROM tblStudentWHERE StudentID = 'StudentID'
D. SELECT * FROM tblStudentWHERE StudentID = @StudentID

Answer: D

Computer Science & Information Technology

You might also like to view...

To convert a database to the Access 2003 format, you can use the Save As option and change the file format

Indicate whether the statement is true or false

Computer Science & Information Technology

The Child Pornography Prevention Act of 1996 prohibited material that appears to be or conveys the impression of child pornography

Indicate whether the statement is true or false.

Computer Science & Information Technology