Module 01: Introduction to PL/SQL

Introduction to PL/SQL

01. PL/SQL block consists of ____ sections.

a. 1

b. 2

c. 3

d. 4

Answer: d

02. The exception section begins with ______ keyword.

a. DECLARE.

b. BEGIN.

c. EXCEPTION.

d. BEGIN EXCEPTION.

Answer: c

03. How many type of block make up a PL/SQL program.

a. 4

b. 3

c. 2

d. 1

Answer: b

04. Executable section begins and ends with ___ keyword. 

a. DECLARE-END.

b. BEGIN-END.

c. DECLARE-EXCEPTION.

d. BEGIN-EXCEPTION.

Answer: b

05. The three tiers architecture are—

a. First tiers, second tiers, third tiers.

b. Client tiers, middle tiers, database tier.

c. First tiers, middle tiers, third tiers.

d. First tiers, middle tiers, database tiers.

Answer: b