Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5.5 Consider the SQL statement: SELECT id, forename, surname FROM authors WHERE forename = 'john' AND surname = 'smith' a. What is this statement intended
5.5 Consider the SQL statement:
SELECT id, forename, surname FROM authors WHERE forename = 'john' AND surname = 'smith'
a. What is this statement intended to do?
b. Assume the forename and surname fields are being gathered from user-supplied input, and suppose the user responds with:
Forename: jo'hn
Surname: smith
What will be the effect?
c. Now suppose the user responds with:
Forename: jo'; drop table authors--
Surname: smith
What will be the effect?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started