Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources]

Benjamin Rosenzweig

نسخه متنی -صفحه : 289/ 177
نمايش فراداده

Lab 15.2 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

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.

    • Answers appear in Appendix A, Section 15.2.