1.3.1 sql

Question 1

SELECT

Answer 1

used to collect fields from a given table

Question 2

FROM

Answer 2

specifies which table the information will come from

Question 3

WHERE

Answer 3

specifes the search criteria

Question 4

ORDER BY

Answer 4

choose which order the data is displayed ascenidng or descending order DESC

Question 5

INSERT INTO

Answer 5

used to insert a new record into a database table

Question 6

UPDATE

Answer 6

update a record

Question 7

DELETE

Answer 7

deletes a record