ADVANCED TOPICS IN COMPILER DESIGN
CODE GENERATION FOR OBJECT ORIENTED LANGUAGES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Benefits of PL/SQL. 1. When multiple SQL statements are combined into PL/SQL blocks, performance improves.
Detailed explanation-2: -It allows the users/developers to run multiple SQL statements at once by wrapping them in a block. It is compatible with SQL. It allows us to use all the SQL statements, data manipulation, cursor handling, transaction statements in PL/SQL blocks. There is no need for conversion between the two of them.
Detailed explanation-3: -Use of Bulk Collect : The Bulk collect statement improves the performance of the PLSQL block. When reading-in lots of related rows, bulk collect can run 10x faster than a conventional loop. This tuning is possible because Oracle reduces context switches into a single operation.
Detailed explanation-4: -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-5: -Make SQL Statements as Efficient as Possible. Make Function Calls as Efficient as Possible. Make Loops as Efficient as Possible. Don’t Duplicate Built-in String Functions. Reorder Conditional Tests to Put the Least Expensive First. Minimize Datatype Conversions. More items