What is the given statement intended to do

Assignment Help Computer Engineering

Reference no: EM131823535

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

c. Now suppose the user responds with: Forename: jo'; drop table authors-- Surname: smith What will be the effect?

Reference no: EM131823535

Questions Cloud

What cause gender inequality in south asian countries : Throughout the paper, I would talk about the history about South Asia a bit first. Secondly, what cause gender inequality in these countries.

Discussion about the veterinarian service : The following table shows a list of pets and their owners that is used by a veterinarian service.

Determining the stock valuation of henry co : Henry Co. is expected to pay a dividend of 13.50 one year from now, and investors expect that dividend to remain stable for the foreseeable future.

What kind of statistical test did the author run : What kind of study design is this (experimental or correlational)? What kind of statistical test did the author run, and how do you know the used this test

What is the given statement intended to do : Consider an SQL statement: SELECT id, forename, surname FROM authors WHERE forename = ‘john' AND surname = ‘smith'.

Where is earth located in relation to the sun : Where is Earth located in relation to the sun? How are the seasons controlled by this relationship with the sun? What are properties of the atmospheric layers?

What is the current value of the company stock : The discount rate is 18%. What is the current value of the company's stock?

What interest rate would her investment have to earn : What interest rate would her investment have to earn in order for her to be able to do so?

Indicate which items should accessible for read-only access : Consider the parts department of a plumbing contractor. The department maintains an inventory database that includes parts information.

User Account

All Pages