Using Explicit Cursors  «Prev  Next»

Fetch Statement - Quiz

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

1. What happens when records are found using a FETCH statement?
Please select all the correct answers.
  A. The FETCH statement closes the cursor.
  B. The FETCH statement opens the cursor.
  C. The FETCH statement loads the current record into variables.
  D. The FETCH statement creates variables to hold the current record.

2. What is the best way to write a cursor?
Please select the best answer.
  A. Use OPEN, FETCH, and CLOSE statements
  B. Use a FOR LOOP statement
  C. Use a LOOP statement
  D. Use a WHILE LOOP statement

3. Which method should be used when the STORE_COST of all records within the PRODUCT table should be increased by 10%?
Please select all the correct answers.
  A. Use a single UPDATE statement for all the records.
  B. Use an explicit cursor.
  C. Use an implicit cursor.
  D. Use one UPDATE statement for each record.