SQL

Question 1

What does SQL stand for

Answer 1

Structured Query Language

Question 2

What info would you need to delete a row in a table

Answer 2

1) The intention was to delete
2) The table to delete it from
3) Which record we want to delete and where to identify it

Question 3

What does SQL do

Answer 3

It allows fast and efficient data base querying

Question 4

Turn the English statement into SQL:

Delete from FORM where Fromname is ‘9C’

Answer 4

SQL:
DELETE FROM Form
WHERE Formname = 9C’

Question 5

Turn the English statement into SQL:

Insert into FORM the values 10C, Miss Badman, B12

Answer 5

SQL:
INSERT INTO Form
VALUES (10C, Miss Badman, B12)