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 is
Incorrect AnswersA: 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
The answer is C:USER_OBJECTS:
LAST_DDL_TIME is the last time it was compiled. TIMESTAMP is the last time it was changed.