Oracle OCP 1Z0 053 Q217(Upgrade Recompile)
217.Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a
multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following
script:
SQL> @utlrp.sql
What is the significance of executing this script?
A. It performs parallel recompilation of only the stored PL/SQL code.
B. It performs sequential recompilation of only the stored PL/SQL code.
C. It performs parallel recompilation of any stored PL/SQL as well as Java code.
D. It performs sequential recompilation of any stored PL/SQL as well as Java code.
Answer: C
实际上，脚本内容：
调用了utlprp.sql
@@utlprp.sql 0
utlprp.sql中存在以下调用：
DECLARE
threads pls_integer := &&1;
BEGIN
utl_recomp.recomp_parallel(threads);
END;
/
multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following
script:
SQL> @utlrp.sql
What is the significance of executing this script?
A. It performs parallel recompilation of only the stored PL/SQL code.
B. It performs sequential recompilation of only the stored PL/SQL code.
C. It performs parallel recompilation of any stored PL/SQL as well as Java code.
D. It performs sequential recompilation of any stored PL/SQL as well as Java code.
Answer: C
实际上，脚本内容：
调用了utlprp.sql
@@utlprp.sql 0
utlprp.sql中存在以下调用：
DECLARE
threads pls_integer := &&1;
BEGIN
utl_recomp.recomp_parallel(threads);
END;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2072902/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
