You need to create a column that allows you to createa uniqu

第1题：

第2题：

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.

第3题：

第4题：

You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

• A、 You will need to open the database with the resetlogs command.
• B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
• C、 You will use the resetlogs version of the create controlfile command.
• D、 You will use the noresetlogs version of the create controlfile command.
• E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

第5题：

You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means， including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do？（）

• A、Create a trigger that rolls back changes to the Price column that violate company policy.
• B、Create a stored procedure that disallows changes to the Price column that violate company policy.
• C、On the Price column， create a check constraint that requires a specified minimum value.
• D、On the Price column， create a foreign key constraint to a table that contains valid prices.

第6题：

Your company Web site includes a page that customers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback. You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform? （）

• A、 Create a nonclustered index on the Comments column. 
• B、 Execute the USE Master Transact-SQL statement. 
• C、 Create a full-text catalog. 
• D、 Create a full-text index on the Comments column.

第7题：

You need to specify the changes to the existing firewall configuration settings that are required by the HTTP endpoint that will be used by the proseware_projects database. What should you do？（）

• A、Create a Web publishing rule on ISA2 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
• B、Create a Web publishing rule on ISA1 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
• C、Create a Web publishing rule on ISA2 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
• D、Create a Web publishing rule on ISA1 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.

第8题：

第9题：

You deploy a windows server 2008 VPN server behind a firewall. Remote uses connect to the VPN by using portable computers that run windows vista with the latest service pack. The firewall is configured to allows only secured web communications. You need to enable remote users to connect as securely as possible. You must achieve this goal without opening any additional ports on the firewall. What should you do?（）

• A、Create an IPsec tunnel.
• B、Create an SSTP VPN connection.
• C、Create a PPTP VPN connection.
• D、Create a L2tp VPN connection.

第10题：

You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）

• A、 Create an INSERT trigger to assign the default value to each item in the table. 
• B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. 
• C、 Create an UPDATE trigger to update the default value for each new item in the table. 
• D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.