Lab 2.2 Self-Review Questions


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

1)

SQL*Plus understands a semicolon as a terminating symbol of a PL/SQL block.

  1. _____ True

  2. _____ False

2)

Substitution variables are used to

  1. _____ read input information provided by a user .

  2. _____ provide a user with output information.

  3. _____ both a and b.

3)

PUT_LINE is one of the procedures from the DBMS_OUTPUT package.

  1. _____ True

  2. _____ False

4)

DBMS_OUTPUT.PUT_LINE writes information to the buffer for storage before it is displayed on the screen.

  1. _____ True

  2. _____ False

5)

The SET command SET SERVEROUTPUT ON SIZE 8000 is used to

  1. _____ enable the DBMS_OUTPUT.PUT_LINE statement only.

  2. _____ change the buffer size only.

  3. _____ enable the DBMS_OUTPUT.PUT_LINE statement and change the buffer size.


Answers appear in Appendix A, Section 2.2 .



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