You run a script that completes successfully using SQL*Plus

第1题：

第2题：

What can be done to enable the debug information for functions to be displayed when using‘ksh -x’to debug a script？（）

• A、Run the script using ‘ksh -fx’.
• B、Run the script using ‘ksh -a function -x’.
• C、Edit the script and add ‘set -x’ at the beginning.
• D、Edit the script and add ‘set -x’ at the beginning of each function.

第3题：

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

第6题：

第7题：

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

• A、 run { open script backup_database； run script backup_database }
• B、 run { engage script backup_database； }
• C、 run { run script backup_database； }
• D、 Run { execute script backup_database； }
• E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

第8题：

第9题：

Given the script   create script db_backup_datafile_script  {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；}   What is the result of running this command？（）  

• A、 The script will fail since you instructed RMAN to back up only one datafile rather than two
• B、 The script will successfully back up datafile 3 without error
• C、 The script will fail since it uses a substitution variable which is not supported
• D、 The execute script command will prompt for the value of and2 since it’s not included in the command
• E、 The script will fail because you cannot use the plus archivelog command when backing up

第10题：

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