| 1) |
The main benefit of using parameters with cursors is that it makes the cursor reusable._____ True _____ False |
| 2) |
Which of the following are acceptable types of parameters to be used with cursors?_____ IN _____ OUT _____ %ROWTYPE _____ IN OUT |
| 3) |
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. |
| 4) |
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. |
| 5) |
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. |
لطفا منتظر باشید ...
