Which table should you query to determine when your procedure was last compiled?
A.
USER_PROCEDURES
B.
USER_PROCS
C.
USER_OBJECTS
D.
USER_PLSQL_UNITS
Explanation:
In the USER_OBJECTS there isIncorrect Answers:
A: USER_PROCEDURES lists all functions and procedures, along with associated properties. For
example, ALL_PROCEDURES indicates whether or not a function is pipelined, parallel enabled or
an aggregate function. If a function is pipelined or an aggregate function, the associated
implementation type (if any) is also identified. It doesn’t have when the object was last complied.
B: There is nothing called USER_PROCS.
D: There is nothing called USER_PLSQL_UNITS