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

Benjamin Rosenzweig

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

Lab 20.1 Self-Review Questions

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

1)

A dynamic SQL string may contain

  • _____ SQL statements only

  • _____ PL/SQL blocks only

  • _____ SQL statements and PL/SQL blocks

  • 2)

    An INTO option of the EXECUTE IMMEDIATE statement is used for

  • _____ single-row queries

  • _____ multi-row queries

  • 3)

    In a dynamic SQL statement, a table name can be specified via a bind argument.

  • _____ TRUE

  • _____ FALSE

  • 4)

    A dynamic SQL statement may be terminated by the semicolon (;)

  • _____ TRUE

  • _____ FALSE

  • 5)

    A dynamic PL/SQL block may be terminated by the forward slash (/)

  • _____ TRUE

  • _____ FALSE

  • Answers appear in Appendix A,

    Section 20.1 .