Question: Consider an SQL statement: SELECT id , forename, surname FROM authors WHERE forename john AND surname smith What is this statement intended to do ?

Consider an SQL statement:
SELECT id, forename, surname FROM authors WHERE forename john AND surname smith
What is this statement intended to do?
Assume the forename and surname fields are being gathered from user-supplied input, and suppose the user responds with:
Forename: john
Surname: smith
What will be the effect?
Now suppose the user responds with:
Forename: jo; drop table authors--
Surname: smith
What will be the effect?
Can you explain the answer in more simple terms please.
Consider an SQL statement: SELECT id , forename,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

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...

Q:

20. (2 pts) Consider an SQL statement: SELECT id, forename, surname FROM authors WHERE forename = 'john' AND surname= = 'smith' a) What is this statement intended to do? b) Assume that the forename...

Q:

Please help me with these questions, i dont understand how to solve for them. 2) List and briefly define four data center availability tiers. 3) Consider an SQL statement: SELECT id, forename,...

Q:

Consider an SOL statement: SELECT id, forename, surname FROM authors WHERE forename = 'david' AND id 939 a. What is this statement trying to search from the database? b. Assume that the firstname and...

Q:

Answer all short answer problems (each question carriss 5 roints) B. UTM D. stateful inspection firewall 1. Explain CIA (Confidentiality, Integrity. Availability) triad in brief 2. List three...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

Org Data- Beginning SQL Question 8 1 pts Consider this SQL statement: SELECT first_name, last_name FROM people What are "first_name" and "last_name"? columns tables rows records

Q:

5 . 5 Consider an SQL statement: SELECT id , forename, surname FROM authors

Q:

Integrate the function. 9-x2 dx 4x 9-x2 9-x 3 O A. In 4 + C 4 19-x 2 9-x + sin 3 O B. In + C 4 9-x 2 C. 3 In 9-x2 +C - 4 X-6A In 9-x2 + C O D. 4

Q:

What is the potential mechanisms behind the impact of mindfulness on telomeres?

Q:

11. If you need to validate a value before assigning it to a Private variable, you enter the validation code in the ___________________ block in a Property procedure. a. Assign b. Get c. Set d....

Q:

A triangle has angle measurements of 54 36 and 90 What kind of triangle is it acute right obtuse triangle has angle measurements of 540, acute right 360, and 900. What kind of triangle is it obtuse