Section 1 Lesson 1: Introduction to PL/SQL

Section 1

1. In which three ways does PL/SQL extend the SQL programming language? (1) Points
(Choose all correct answers)
By adding procedural constructs. (*)
By adding compound constructs.
By adding iterative control. (*)
By adding conditional control. (*)

2.  Which of the following statements is true? (1) Points
You can embed PL/SQL statements within SQL code.
You can embed SQL statements within PL/SQL code. (*)
You can embed procedural constructs within SQL code.
None.

3.  Which of the following statements is true? (1) Points
PL/SQL is an Oracle proprietary, procedural, 3GL programming language. (*)
PL/SQL is an Oracle proprietary, procedural, 4GL programming language.
PL/SQL is an Oracle proprietary, nonprocedural, 3GL programming language.
PL/SQL is an ANSI-compliant, procedural programming language.

4. PL/SQL stands for:  (1) Points
Processing Language for SQL.
Procedural Language extension for SQL. (*)
Primary Language for SQL.
Proprietary Language for SQL.

5.  Nonprocedural languages allow the programmer to produce a result when a series of steps are followed. True or False? (1) Points
True
False (*)

6.  Which of the following statements about SQL is true? (1) Points
SQL is an Oracle proprietary, nonprocedural, 4GL programming language.
SQL is an Oracle proprietary, procedural, 3GL programming language.
SQL is an ANSI-compliant, nonprocedural, 4GL programming language. (*)
SQL is an ANSI-compliant, procedural, 4GL programming language.