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 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.



Leave a Reply 0

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