单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure 

第1题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

• A、The DBMS_JOB package
• B、The BACKUP_JOB package
• C、The DBMS_BACKUP_RESTORE package
• D、The calendar tool in the Operating System （OS）
• E、The backup scheduler in Enterprise Manager （EM）
• F、The DBMS_BACKUP_SCHEDULER packager inline mode

第2题：

You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

• A、Hot backup
• B、Online backup
• C、consistent backup
• D、incremental backup
• E、inconsistent backup

第3题：

You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

• A、Database Control
• B、Management Server
• C、Management Repository
• D、Application Server Control
• E、Oracle Management Agent

第4题：

Every morning, you inspect your company's development and staging servers. You do this to ensure that the servers have the same versions of all files in your Web application.For security reasons, you can only access the staging server through FTP.You need to synchronize files from the staging server so that the staging server matches the development server.You want to achieve this goal by using the minimum amount of administrative effort. Which tool should you use?（）

• A、FTP
• B、XCOPY
• C、the Publish Web tool
• D、the Copy Web tool

第5题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）

• A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 
• B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 
• C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. 
• D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）

• A、AFTER CREATE
• B、AFTER SUSPEND
• C、BEFORE CREATE
• D、AFTER TRUNCATE
• E、BEFORE SUSPEND
• F、AFTER INSERT OR DELETE OR DELETE
• G、BEFORE INSERT OR DELETE OR DELETE

第14题：

You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and perform tablespace recovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第15题：

You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

• A、 create a hash cluster to store the data
• B、 create an index cluster to store the data
• C、 create a partitioned table to store the data
• D、 create a sorted hash cluster to store the data
• E、 create a heap table with rowid to store the data

第16题：

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

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：