多选题You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）AParallel compilation of only the stored PL/SQL codeBSequential recompilation

第1题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

• A、It must be executed from the Oracle Database 11g environment.
• B、It must be executed only after the SYSAUX tablespace has been created.
• C、It must be executed from the environment of the database that is being upgraded.
• D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第2题：

You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）

• A、On the Oracle server. 
• B、Locally in each form module. 
• C、In an attached PL/SQL library 
• D、On your file network server.

第3题：

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）

• A、It is a SQL script.
• B、It is a PL/SQL file.
• C、It is an operating system （OS） file.
• D、It is a Recovery Manager （RMAN） script

第4题：

You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

• A、SQL script
• B、PL/SQL script
• C、Operating System （OS） script
• D、Enterprise Manager （EM） script
• E、Recovery Manager （RMAN） script

第5题：

You issue this RMAN command：   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   （database include current controlfile）；   sql ‘alter database archive log current’；   }  Which three statements are true about the Level0Backup script you just created？（）

• A、The script is stored only in the control file.
• B、The script is stored only in the recover catalog.
• C、The script can be executed only by using the RMAN RUN command.
• D、The commands of the script can be displayed with the LIST command.
• E、The commands of the script can be displayed with the PRINT command.
• F、The commands of the script can be displayed with the REPORT command.

第6题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（）  

• A、You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured 
• B、You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured 
• C、You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured 
• D、You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

• A、 It must be executed from the Oracle Database 11g environment.
• B、 It must be executed only after the SYSAUX tablespace has been created.
• C、 It must be executed from the environment of the database that is being upgraded.
• D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第14题：

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.

第15题：

Which statement about using RMAN stored scripts is true？（）  

• A、 To create and execute an RMAN stored script，you must use a recovery catalog.
• B、 When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.
• C、 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
• D、 When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.

第16题：

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.

第17题：

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）

• A、Parallel compilation of only the stored PL/SQL code
• B、Sequential recompilation of only the stored PL/SQL code
• C、Parallel recompilation of any stored PL/SQL code
• D、Sequential recompilation of any stored PL/SQL code
• E、Parallel recompilation of Java code
• F、Sequential recompilation of Java code

第18题：

You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?（） 

• A、Execute unit test scripts for each stored procedure in each database.
• B、Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results.
• C、Set the database compatibility level on the database servers to 80.
• D、Execute the application user interface test scripts to verify proper operation.

第19题：

第20题：

第21题：

第22题：

第23题：