You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.The customer service representatives in your company add and e

第1题：

第2题：

第3题：

You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）

• A、Monitor thealert.logfile
• B、Enable server-side SQL tracing for user sessions
• C、Enable fine-grained auditing for the customer table
• D、Enable Fine-Grained Access Control （FGAC） for the customer table
• E、Write a database trigger on the customer table on the SELECT event

第4题：

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. A SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect. Which action should be performed？（）

• A、A stored procedure should be created， and changes are disallowed by the procedure to the Price column that violates company policy.
• B、On the Price column， a check constraint should be created， and a specified minimum value is required by the check constraint.
• C、A trigger should be created， and changes are rolled back by the trigger to the Price column that violates company policy.
• D、On the Price column， a foreign key constraint is created to a table that valid prices are included.

第5题：

You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do？（）

• A、Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
• B、Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
• C、Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
• D、Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.

第6题：

You work in a company which 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 DB1 in the instance. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below， which Transact-SQL statement should you execute？（）

• A、ALTER TABLE Service.Table SWITCH TO Costs.Table1; 
• B、ALTER SCHEMA CostsTRANSFER Service.Table; 
• C、ALTER USER Service WITH DEFAULT_SCHEMA = Costs; 
• D、ALTER AUTHORIZATION ON Service.Table1 TO Costs;

第7题：

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. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized.  Which action should be performed to finish the task？（）

• A、A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
• B、A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.
• C、On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.
• D、A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.

第8题：

You use a Windows 2000 Professional computer at home. You need to access shared files on a server named server1. This server is on your company’s network and is not accessible from the Internet. Your company’s network also includes a third party VPN server that is accessible from the Internet. You dial in to your Internet service provider and then create a VPN connection to your company’s VPN server. After the connection is successfully established， you run the net view //server1 command and receive the following error ‘the server is inaccessible or could not be found’. You need to access the shared files on server 1. What should you do？（）

• A、Stop and then start the TCP/IP NetBIOS helper service on your computer.
• B、Stop and then start the DNS client service on your computer.
• C、Add a HOSTS entry for server1 to your computer.
• D、Add a LMHOSTS entry for server1 to your computer.

第9题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances.  Which service should you start?（）  

• A、Server 
• B、SQL Server Agent 
• C、SQL Server Browser 
• D、SQL Active Directory Helper

第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 a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）

• A、A new partition function should be created 
• B、You should change the existing partition scheme 
• C、You should use a Merge clause to change the existing partition function 
• D、You should use a Split clause to change the existing partition function 

第11题：

第12题：

第13题：

第14题：

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）

• A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
• B、Create a CHECK constraint.
• C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
• D、Create a DML AFTER trigger that writes the failed records to a file or table.

第15题：

 You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports.  What should you do?（）

• A、 Publish the data in the database as an XML Web service by using the FOR XML AUTO clause. 
• B、 Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service. 
• C、 Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service. 
• D、 Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.

第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 a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

• A、You should use local Service account
• B、You should use network Service account
• C、You should use domain account
• D、You should use local System account

第17题：

Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

• A、 Create a FOR trigger. 
• B、 Create an INSTEAD OF trigger. 
• C、 Create an AFTER trigger. 
• D、 Create a DDL trigger.

第18题：

You need to design a hosting service option for customers who want to access their databases by using their own Active Directory domain accounts. What should you do？（）

• A、Design a hosting service option that duplicates each customer’s domain user account as SQL Serverlogin account.
• B、Design a hosting service option that provides VPN-based connectivity from each customer’s network tothe SQL Server computer that hosts that customer’s daabase or databases.
• C、Design a hosting service option that provides a dedicated server to each customer.Join that server to that customer’s Active Directory domain
• D、Design a hosting service option that configures a unique instance of SQL Server 2005 for each customer.Configure that instance to use Integrated Windows authentication.

第19题：

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 which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?（）  

• A、On the Products table, you should create a view. 
• B、On the RadioSize column, you should create a clustered index 
• C、On the RadioSize column, you should create a filtered index 
• D、On the RadioSize column, you should create a unique clustered index

第20题：

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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） 

• A、You should use SQLServer:Buffer Manager
• B、You should use SQLServer:Memory Manager 
• C、You should use SQLServer:Databases 
• D、You should use SQLServer:Access Methods

第21题：

You work in a company which 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 n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）

• A、You should use row compression 
• B、You should use page compression 
• C、You should use backup compression 
• D、You should use windows NTFS file system compression

第22题：

第23题：