Read The Following Code 3


  • 21 Mar, 2012

    Read the following code40. CREATE OR REPLACE PROCEDURE calculate_budget IS41. v_budget studio.yearly_budget%TYPE;42. BEGIN43. v_budget := get_budget(11);44. IF v_budget < 3000045. THEN46. set_budget(11,30000000);47. END IF;48. END;You are about to add an argument to CALCULATE_BUDGET. What effect will this have?1. The GET_BUDGET function will be marked invalid and must be recompiled before the next execution.2. The SET_BUDGET function will be marked invalid and must be recompiled before the next execution.3. Only the CALCULATE_BUDGET procedure needs to be recompiled.4. All three procedures are marked invalid and must be recompiled.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.