Question: 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

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 Databases Questions!

Q:

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

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:

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:

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:

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:

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

Q:

How could a well-managed database help the company better achieve its goals? v Hint: refer to Text Chapter 1 for " Advantages of database approach " and apply that understanding to the GG project...

Q:

What is the intent of no-fault insurance? How does no-fault insurance generally work? What is a disadvantage of no-fault insurance?

Q:

Walters Corporation manufactures water skis through two processes: Molding and Packaging. In the Molding Department fiberglass is heated and shaped into the form of a ski. In the Packaging...

Q:

Suppose you want to buy at car that costs $ 2 8 , 0 0 0 . You can finance the purchase the car through the auto dealership at 4 % per year, compounded monthly ( meaning you will make monthly payments...

Q:

What is the function of human resource management? a . monitor and control organizational element b . hiring employees c . creating job designs and analysis d . job performance evaluations e ....

Q:

Which of the following approaches to organisational data gathering goes against the principles of organisational informed consent? a Taking internal organisational documents without permission. b The...

Q:

To what extent is your thinking determined by features like the organisational culture of your employing organisation, your previous work experience, your national cultural background, your political...

Q:

What strategies might you adopt to manage the time pressures of organisational and academic deadlines and produce a literature review of good quality?