What is the significance of executing this script?

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?

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 sequential recompilation of only the stored PL/SQL code.

B.
It performs parallel recompilation of any stored PL/SQL as well as Java code.

C.
It performs sequential recompilation of any stored PL/SQL as well as Java code.

D.
It performs parallel recompilation of only the stored PL/SQL code.



Leave a Reply 0

Your email address will not be published. Required fields are marked *