COMPILER DESIGN

ADVANCED TOPICS IN COMPILER DESIGN

CODE GENERATION FOR OBJECT ORIENTED LANGUAGES

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

PL/SQL can be used not only with an Oracle database, but also with any kind of relational database. True or False?

A	True
B	False
C	Either A or B
D	None of the above

Explanation:

Detailed explanation-1: -PL/SQL and SQL can be used with many types of databases, including Oracle. PL/SQL allows basic program logic and control flow to be combined with SQL statements.

Detailed explanation-2: -PL/SQL only can execute in an Oracle Database. It was not designed to use as a standalone language like Java, C#, and C++. In other words, you cannot develop a PL/SQL program that runs on a system that does not have an Oracle Database. PL/SQL is a high-performance and highly integrated database language.

Detailed explanation-3: -Answer : C. Q 2-Which of the following is not true about the PL/SQL language? A-PL/SQL’s general syntax is based on that of ADA and Pascal programming language. B-Apart from Oracle, PL/SQL is available in TimesTen in-memory database and IBM DB2.

Detailed explanation-4: -Q 19-Which of the following is not true about the PL/SQL functions? A-A PL/SQL function is same as a procedure except that it returns a value.

Detailed explanation-5: -PL/SQL is Oracle’s procedural language extension to SQL. PL/SQL allows you to mix SQL statements with procedural constructs. PL/SQL provides the capability to define and execute PL/SQL program units such as procedures, functions, and packages.

There is 1 question to complete.