Which action would fix the problem and make the PL/SQL procedure usable?

In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?

Question:

Which action would fix the problem and make the PL/SQL procedure usable?

Options:

Recompile the PL/SQL procedure.

Modify the procedure to run with a definer’s right.

Modify the procedure to run with an invoker’s right.

Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.

Correct Answer

The Correct Answer for this Question is

Recompile the PL/SQL procedure.