19.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
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、它仍然有效。
B、所有选项的在线表格重定义都使它无效,但在下次被使用时自动得到验证。
C、所有选项的在线表格重定义都使它无效,并且在在线表重定义中被自动编译。
D、只有存储参数进行了修正才会使它无效,并且在下次被使用时自动得到验证。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81227/viewspace-2121522/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81227/viewspace-2121522/