In order to test your progress, you should be able to answer the following questions.
The main benefit of using parameters with cursors is that it makes the cursor reusable.
_____ True
_____ False
Which of the following are acceptable types of parameters to be used with cursors?
_____ IN
_____ OUT
_____ %ROWTYPE
_____ IN OUT
By adding the keywords FOR UPDATE at the end of a cursor, you are
_____ simply alerting the DBA that you are updating a table.
_____ freeing up rollback segments for the update.
_____ locking the indicated rows for an update.
_____ creating a bind variable.
Adding the keywords WHERE CURRENT OF to a FOR UPDATE cursor causes which of the following to take place?
_____ The DBA gets annoyed.
_____ Rows are locked and unlocked one at a time.
_____ The update occurs for the current record in the cursor.
_____ The scope of the cursor is increased.
The principal difference between a FOR UPDATE cursor without a WHERE CURRENT OF clause and one with a WHERE CURRENT OF clause is that
_____ without the clause the update needs to have a WHERE clause.
_____ rows are only locked with the extra clause present.
_____ only the items specified in the WHERE CURRENT OF clause are locked.
_____ processing will only occur for the current row of the cursor.
Answers appear in Appendix A, Section 15.2.