COMPILER DESIGN

ADVANCED TOPICS IN COMPILER DESIGN

CODE GENERATION FOR OBJECT ORIENTED LANGUAGES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following statements about PL/SQL and SQL is true?
A
PL/SQL and SQL are both Oracle proprietary programming languages.
B
PL/SQL and SQL can be used with many types of databases, including Oracle.
C
PL/SQL allows basic program logic and control flow to be combined with SQL statements.
D
PL/SQL and SQL are both ANSI-compliant
Explanation: 

Detailed explanation-1: -Answer : D. Q 3-Which of the following is true about the PL/SQL language? A-PL/SQL provides access to predefined SQL packages.

Detailed explanation-2: -What is TRUE about PL/SQL functionalities? Conditions and loops are fundamental elements of procedural languages like PL/SQL. Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types.

Detailed explanation-3: -Which of the following is true about scalar data types in PL/SQL? They hold single values with no internal components. Examples of scalar data types are NUMBER, DATE, or BOOLEAN.

Detailed explanation-4: -Which of the following is true about PL/SQL package body? The package body has methods declared in package specification and private.

There is 1 question to complete.