Different SQL Operations - Quiz Explanation

The answers you selected are indicated below, along with text that explains the correct answers.
 
1. You need to insert a row into the customer table. Which statement will accomplish this?
Please select the best answer.
  A. PUT (information) INTO customer WHERE CustomerID=NEW
  B. SAVE (information) INTO Customer
  C. INSERT INTO Customer (what columns) VALUES (information)
  D. INSERT INTO Customer (information)
  The correct answer is C. The syntax for the insert statement is INSERT INTO table (columns) VALUES (information).

2. If you want to remove a row from the customer table, what statement will you use?
Please select the best answer.
  A. REMOVE FROM Customer WHERE ...
  B. ERASE FROM Customer
  C. DELETE FROM Customer IF customerID=...
  D. DELETE FROM Customer WHERE customerID=...
  The correct answer is D. You use the DELETE FROM statement to remove rows from the table. You will also need to indicate the customer ID (unique value) to indicate which row to remove.

3. You need to make a change to an existing row in the table. Which statement will you use?
Please select the best answer.
  A. UPDATE
  B. CHANGE
  C. DELETE then INSERT a new row
  D. MODIFY
  The correct answer is A. To make changes to an existing row, you use the UPDATE statement. You could delete and then insert a new row, but that would require statements that you don't really need if you just use the UPDATE statement. Simply indicate the table and the values to update. You can also include the WHERE clause if needed to limit the scope of your UPDATE statement.

4. Which of the following statements is incorrect?
Please select the best answer.
  A. SELECT ALL FROM Customer
  B. SELECT * FROM Customer WHERE CustomerID=5
  C. SELECT * FROM Customer Where CustomerID=5
  D. SELECT * FROM Customer IF CustomerID=5
  The correct answer is D. In this statement, the IF clause is not valid. It should be WHERE.