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 codeB、Sequential recompilation of only the stored PL/SQL codeC、Parallel recompilation of any stored PL/SQL codeD、Sequential recompilation of any stored PL/SQL codeE、Parallel recompilation of Java codeF、Sequential recompilation of Java code
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
相关考题：
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 codeB. Sequential recompilation of only the stored PL/SQL codeC. Parallel recompilation of any stored PL/SQL codeD. Sequential recompilation of any stored PL/SQL codeE. Parallel recompilation of Java codeF. Sequential recompilation of Java code
You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler（）A、XML scriptB、PL/SQL scriptC、Operating system scriptThis document was downloaded from = http：//www.amaderforum.comD、Recovery Manager （RMAN） script
Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A、Join the two servers by using the four-part syntax of server.database.schema.table.B、Reference SQL2 by using an alias.C、Add SQL2 as a remote server to SQL1.D、Add SQL2 as a linked server to SQL1.
You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）A、Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.B、Ensure that the stored procedure and the tables are owned by the same database user.C、Ensure that the stored procedure and the tables use the same database schema.D、Configure the multiuser database option on both databases.E、Configure the cross-database ownership chaining option on both databases.
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.
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.
You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace. What methods can you use to re/x7fcreate the indexes？（）A、Data PumpB、SQL scriptsC、SQL*LoaderD、Flashback databaseE、Recovery Manager （RMAN） script
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.
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.
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
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）A、Library cache B、Row cacheC、Dictionary cache D、Large area E、Buffer cache
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.
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 scriptB、PL/SQL scriptC、Operating System （OS） scriptD、Enterprise Manager （EM） scriptE、Recovery Manager （RMAN） 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.
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.
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
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.
单选题You are using Enterprise Manager to schedule backups for your database. Which type of script wouldbe generated by the backup scheduler（）AXML scriptBPL/SQL scriptCOperating system scriptDRecovery Manager （RMAN） script
单选题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.
单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）ALibrary cache BRow cacheCDictionary cache DLarge area EBuffer cache
多选题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 of only the stored PL/SQL codeCParallel recompilation of any stored PL/SQL codeDSequential recompilation of any stored PL/SQL codeEParallel recompilation of Java codeFSequential recompilation of 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.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.
单选题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.
单选题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？（）ASQL scriptBPL/SQL scriptCOperating System （OS） scriptDEnterprise Manager （EM） scriptERecovery Manager （RMAN） script
单选题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?（）AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
单选题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?（）AIt performs parallel recompilation of only the stored PL/SQL code.BIt performs sequential recompilation of only the stored PL/SQL code.CIt performs parallel recompilation of any stored PL/SQL as well as Java code.DIt performs sequential recompilation of any stored PL/SQL as well as Java code.
单选题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？ （）AIt is a SQL script.BIt is a PL/SQL file.CIt is an operating system （OS） file.DIt is a Recovery Manager （RMAN） script