SQL Data Update

Question 1

What SQL statement is used to add new data?

Answer 1

INSERT

Question 2

What clause is used to filter which rows to delete or update?

Answer 2

WHERE

Question 3

What happens if you omit the WHERE clause in a DELETE?

Answer 3

All rows in the table will be deleted.

Question 4

True or False: You must always list column names in an INSERT statement.

Answer 4

False. It’s optional if you’re inserting into all columns in order.

Question 5

How do you increase a numeric column value by 10%?

Answer 5

SET column = column * 1.10