Oracle
1Z0-052 · Question #192
1Z0-052 Question #192: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #192. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
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?
Options
- ARecompile the PL/SQL procedure.
- BModify the procedure to run with a definer's right.
- CModify the procedure to run with an invoker's right.
- DGrant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#invalid object#PL/SQL recompile#object status#schema object validity