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

  1. _____ SQL statements only

  2. _____ PL/SQL blocks only

  3. _____ SQL statements and PL/SQL blocks

2)

An INTO option of the EXECUTE IMMEDIATE statement is used for

  1. _____ single-row queries

  2. _____ multi-row queries

3)

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

  1. _____ TRUE

  2. _____ FALSE

4)

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

  1. _____ TRUE

  2. _____ FALSE

5)

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

  1. _____ TRUE

  2. _____ FALSE


Answers appear in Appendix A, Section 20.1 .



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net