59.In your database, the current status of a PL/SQL procedure has become INVALID. Which action woul

59.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?
A.Recompile the PL/SQL procedure.
B.Modify the procedure to run with a definer's right.
C.Modify the procedure to run with an invoker's right.
D.Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.
答案：A
解析：题中说的是存储过程失效了，应该怎样处理，这里应该重新编译一下
A:重新编译
B和c是说存储过程执行的时候应该是定义者还是调用者的权限
D:将存储过程执行权限设置为public
BCD都是说权限的和和题目没有关系