Oracle Database Advanced PL SQL 12c 1z0 148
© examsiri.com
Question : 48 of 54
Marks:
+1,
-0
Your company’s executive team voted to give a one-time special bonus, the amount of which is to be based on number of years of service. The bonus table will be updated using a procedure called update_bonus().
Examine this PL/SQL block which shows the logic to calculate the bonus:
1. Remove the service_days calculation statement.
2. Move bonus1 and bonus2 initializations out of the loop.
3. Inline the update_bonus() subprogram.
4. Call update_bonus(), passing the literal bonus amount instead of the bonus1 or bonus2 variables
Which set of optimizations will be performed if this block is compiled with PLSQL_OPTIMIZE_LEVEL = 2?
Examine this PL/SQL block which shows the logic to calculate the bonus:
Consider these possible optimization actions:
1. Remove the service_days calculation statement.
2. Move bonus1 and bonus2 initializations out of the loop.
3. Inline the update_bonus() subprogram.
4. Call update_bonus(), passing the literal bonus amount instead of the bonus1 or bonus2 variables
Which set of optimizations will be performed if this block is compiled with PLSQL_OPTIMIZE_LEVEL = 2?
Go to Question: