Oracle PL[s]SQL by Example

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 .

Related

Категории