ADVANCED TOPICS IN COMPILER DESIGN
CODE GENERATION FOR OBJECT ORIENTED LANGUAGES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
By adding conditional control.
|
|
By adding iterative control
|
|
By adding procedural constructs.
|
|
By adding compound constructs.
|
Detailed explanation-1: -You can embed SQL statements within PL/SQL code. In which three ways does PL/SQL extend the SQL programming language? By adding conditional control, iterative control and procedural constructs. PL/SQL allows basic program logic and control flow to be combined with SQL statements.
Detailed explanation-2: -In which three ways does PL/SQL extend the SQL programming language? (Choose all correct answers) By adding conditional control. By adding procedural constructs. By adding compound constructs.
Detailed explanation-3: -PL/SQL is Oracle’s procedural language extension to SQL.
Detailed explanation-4: -PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency.
Detailed explanation-5: -PL/SQL (procedural language extension to Structured Query Language) In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language.