Which is true about invalid PL/SQL objects?
Which is true about invalid PL/SQL objects?
Question:
Which is true about invalid PL/SQL objects?
Options:
They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.
They are automatically recompiled against the new definition of a referenced object when they are called.
They are automatically recompiled against the new definition of a referenced object at the same time as the modified referenced object.
They can be manually recompiled only by using SQL commands.
Correct Answer
The Correct Answer for this Question is
They are automatically recompiled against the new definition of a referenced object when they are called.