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
You might also like to view...
Which statement prompts the user for a name and then assigns the name to the string variable strName?
(A) strName = InputBox("What is your first name?", "First Name") (B) strName = MessageBox.Show("What is your first name?" "First Name") (C) InputBox("What is your first name?", ";First Name") = strName (D) MessageBox.Show "What is your first name?", "First Name" = strName
What does Davis mean when he says that a professional "puts profession first"?
What will be an ideal response?
SkyDrive uses ________ to control access to your files
A) Windows Live Security B) Windows Live Encryption C) a Microsoft Account D) Windows Live Plus!
Case Question 2Vanessa is responsible for adding interactivity to her company's Web site. She is concerned that adding more images might make the pages look crowded. Instead, she decides to use an Image Swap on the page where she is currently working.After doing some research, Vanessa discovers that the image swap behavior replaces one image with another upon a specified event, usually a ____.
A. page refresh B. page load C. mouseover D. mouse click