ocp-520

最新推荐文章于 2019-08-08 11:31:18 发布

佳岳

最新推荐文章于 2019-08-08 11:31:18 发布

阅读量1.7k

点赞数

分类专栏： OCP-1Z0-053

OCP-1Z0-053 专栏收录该内容

674 篇文章 0 订阅

订阅专栏

QUESTION NO: 520
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table
redefinition. What happens to the PL/SQL procedure after the online table redefinition?
A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time
it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online
redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated
the next time it is used.
Answer: A

PL / SQL过程只查询那些重新定义表的列，那些表是被在线表重定义没有改变。在线表重新定义之后， PL / SQL过程会发生什么事？（表
结构的分区维护，不影响数据定义）

A.它仍然有效。