Question

PL/SQL = a procedural extension of Oracle SQL. It's basically a combination of procedural 3GL + declarative 4GL. Think of SQL + programming languages combined (so you have variables, types, blocks, control statements, functions, etc.).

Options:
A. SQL/3GL
B. PL/4GL
C. ProSQL
D. SQL/PL

Answer 1

PL/SQL is an extension of SQL used in Oracle databases that combines features of both procedural programming languages (3GL) and declarative programming environments (4GL). The correct option that describes PL/SQL is B. PL/4GL.

Step-by-step explanation:

The question pertains to PL/SQL, which is a procedural language extension for SQL used in the Oracle relational database system. It incorporates elements of both 3rd generation languages (3GL), which are high-level programming languages like C, and 4th generation languages (4GL), which are more advanced environments that typically include database-related commands and can be more declarative in nature.

PL/SQL adds the capability of procedural programming, which includes the use of variables, control structures like loops and conditionals, and the ability to define functions and procedures, to the already powerful SQL database language. This combination is designed to provide a more powerful and flexible way to write complex database interactions that can include sophisticated business logic.

Following the description provided, the best option from the given choices is B. PL/4GL, which acknowledges PL/SQL's combination of both a procedural (3GL) and a declarative (4GL) aspect.