ADVANCED TOPICS IN COMPILER DESIGN
CODE GENERATION FOR OBJECT ORIENTED LANGUAGES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Create custom reports
|
|
|
Manage database tasks such as security
|
|
|
All of these can be done
|
|
|
Create complex applications
|
Detailed explanation-1: -Which of the following can be done using PL/SQL? Create complex applications. Retrieve and modify data in Oracle database tables. Manage database tasks such as security.
Detailed explanation-2: -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.
Detailed explanation-3: -PL/SQL has three categories of control statements: conditional selection statements, loop statements and sequential control statements.
Detailed explanation-4: -Functions include EXISTS, COUNT, LIMIT, FIRST, LAST, PRIOR, and NEXT; operations include EXTEND, TRIM, and DELETE. EXISTS, PRIOR, NEXT, TRIM, EXTEND, and DELETE all take collection subscripts as arguments, which are generally integers but can also string in the case of associative arrays.
Detailed explanation-5: -PL/SQL is tightly integrated with SQL. It offers extensive error checking. It offers numerous data types. It offers a variety of programming structures. It supports structured programming through functions and procedures. It supports object-oriented programming. More items