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.sqlWhat 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.
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.sqlWhat 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.
相关考题:
Oracle数据库的JDBC驱动程序类名及完整包路径为() A.jdbc.driver.oracle.OracleDriverB.jdbc.oracle.driver.OracleDriverC.driver.oracle.jdbc.OracleDriverD.oracle.jdbc.driver.OracleDriver
WhichofthefollowingstatementsistrueregardingtheinitializationparameterDIAGNOSTIC_DEST?()Thedefaultvalueisthevalueoftheenvironmentvariable$ORACLE_HOME;if$ORACLE_HOMEisn’tset A.thenthedefaultissetto$ORACLE_BASE Thedefaultvalueisthevalueoftheenvironmentvariable$ORACLE_BASE;if$ORACLE_BASEisn’tset,B.thenitissetto$ORACLE_HOMEC.DIAGNOSTIC_DESTisalwaysequalto$ORACLE_HOMED.DIAGNOSTIC_DESTisalwaysequalto$ORACLE_BASE
Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile()A.ORACLE_HOME/dbsB.ORACLE_HOME/rdbmsC./u01/app/oracle/admin/orcl/adumpD./u01/app/oracle/flash_recovery_areaE.ORACLE_BASE/diag/rdbms/orcl/orcl/alertF.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
一下对于Oracle文件系统描述错误的是()?A、*nix下Oracle的可执行文件在$Oracle_HOME/bin/Oracle,$Oracle_HOME/bin也应该包含在路径环境变量内B、Windows下Oracle的可执行文件在%Oracle_HOME%\bin\OraclE.exe,其他C、硬件加密D、固件加密
ORACLE初始化参数文件的默认路径是:() A.对于UNIX,在$ORACLE_HOME/dbsB.对于UNIX,在$ORACLE_HOME/dbs/adminC.对于Linux,在%ORACLE_HOME%\databaseD.对于Windows,在%ORACLE_HOME%\dbsE.对于Windows,在%ORACLE_HOME%\database\admin
ORACLE数据库自带的opath工具在下面哪个目录下?() A.$ORACLE_HOME/network/adminB.$ORACLE_HOME/binC.$ORACLE_HOME/OPAtchD.$ORACLE_BASE