Which is true about invalid PL/SQL s?
A)They are automatically recompiled against the new definition of a referenced when they are called.
B)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 .
C)They are automatically recompiled against the new definition of a referenced at the same time as the referenced is modified.
D)They can be manually recompiled only by using SQL commands.
Answer: A
赵:
A 译:它们在被调用时根据引用对象的新定义自动重新编译。
B 译:如果在 PL/SQL 对象中引用的表上执行 DDL,则必须手动重新编译它们才能使用它们。
继续阅读与本文标签相同的文章
-
干货分享 | 阿里PB级Kubernetes日志平台建设实践
2026-05-22栏目: 教程
-
高并发的中断下半部tasklet实例解析
2026-05-22栏目: 教程
-
JVM-SANDBOX:从阿里精准测试走出的开源贡献奖
2026-05-22栏目: 教程
-
Alibaba Cloud Linux 2 开源后又有什么新动作?
2026-05-22栏目: 教程
-
为什么技术人一定要懂点“可信计算”?
2026-05-22栏目: 教程
