Answers

Question and Answer:

  Home  SQL

⟩ Read the following code 3?

Read the following code

40. CREATE OR REPLACE PROCEDURE calculate_budget IS

41. v_budget studio.yearly_budget%TYPE;

42. BEGIN

43. v_budget := get_budget(11);

44. IF v_budget < 30000

45. THEN

46. 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.

 187 views

More Questions for you: