单选题A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design

第1题：

What is the proper way to ensure that updates to the /etc/aliases file are seen by sendmail？（）

• A、Refresh the named daemon
• B、Run the alias command
• C、Refresh the snmpd daemon
• D、Run the sendmail -bi command

第2题：

A customer has a combination of fifteen Windows file servers with direct attached storage and three Power Systems with AIX database servers SAN attached to a DS4700. They would like to upgrade and plan for 40 TB capacity. The customer needs to move to a more scalable storage system to include all servers. Which of the following would be most appropriate to ask first？（）

• A、What are Disaster Recoveryplans
• B、What are plans for datamigration
• C、What storage system space isavailable
• D、DoesiSCSI meet the needs

第3题：

You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）

• A、 by using the STATUS command of the Listener control utility
• B、 by using the STATUS L1 command of the Listener control utility
• C、 by using the SHOW RULES command of the Listener control utility
• D、 by using the SET PASSWORD command of the Listener control utility
• E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

第4题：

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 a database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）  

• A、You should run the bulk copy program utility along with an output file and no format file
• B、You should run the SQLCmd utility and save the output to a file
• C、You should run the SQL Import and Export Data Wizard and save the output to a file.
• D、You should run the bulk copy program utility along with a format file and an output file.

第5题：

Your company has a single Active Directory domain. You have 30 database servers that run Windows Server 2008 R2.   The computer accounts for the database servers are stored in an organizational unit （OU） named Data.   The user accounts for the database administrators are stored in an OU named Admin. The database administrators are members of a global group named D_Admins.   You must allow the database administrators to perform administrative tasks on the database servers. You must prevent the database administrators from performing administrative tasks on other servers. What should you do？（）

• A、Deploy a Group Policy to the Data OU.
• B、Deploy a Group Policy to the Admin OU.
• C、Add D_Admins to the Domain Admins global group.
• D、Add D_Admins to the Server Operators built-in local group.

第6题：

Your network contains an Exchange Server 2010 Mailbox server.The server has one mailbox database.A user named User1 reports that he has multiple corrupted e-mail messages in his mailbox.You need to recover User1ˉs -mail messages.The solution must not delete any other e-mail messages in the mailbox database.What should you do？（）

• A、Create a new Mailbox Recovery Database， restore a backup of the database file， and then run the Export-Mailbox cmdlet.
• B、Create a new Mailbox Recovery Database， restore a backup of the database file， and then run the Restore-Mailbox cmdlet.
• C、Create a database availability group （DAG）， restore a backup of the mailbox database file， and then run the Restore-Mailbox cmdlet.
• D、Create a database availability group （DAG）， restore a backup of the mailbox database file， and then run the Export-Mailbox cmdlet.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

• A、db2advis -d proddb -i workload.sql -P  
• B、db2advis -d proddb -i workload.sql -partitioning  
• C、db2advis -d proddb -i workload.sql -m P  
• D、db2advis -d proddb -i workload.sql -m ALL 

第14题：

You work as a database administrator for Certkiller .com. 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 performtablespacerecovery
• 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 observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

• A、RMAN would use the current operating system location to place the backup.
• B、RMAN would use the control file of the target database to maintain the backup.
• C、RMAN would use the recovery catalog of the target database to maintain the backup.
• D、RMAN would use the control file of the target database to maintain the backup metadata. 
• E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

第16题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）

• A、The sp_executesql batches are not being recovered from the procedure cache.
• B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
• C、One new stored procedure is created by a database administrator.
• D、Ad hoc batches are not being recovered from the procedure cache.

第17题：

You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do？（）

• A、Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
• B、Query the sys.server_permissions table on Server1.
• C、Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
• D、Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：