Table Querying   «Prev  Next»

Different SQL Operations - Quiz

Deciding which statements to use for different operations

Each question is worth one point. Select the best answer or answers for each question.
 

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)

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=...

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

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
Correct answers:

Your Score: 0