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.

Explanation:
Recompile invalid objects with utlrp.sql



Leave a Reply 0

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