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: 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?

Question

Examsnet · Accepted Answer

Correct Answer is : 1 and 2 only

Oracle Database Advanced PL SQL 12c 1z0 148