You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort.
What should you do？（）

单项选择题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）

A.Implement parameterized Transact-SQL queries in the application.
B.Implement Transact-SQL stored procedures in the database.
C.Implement CLR stored procedures in the database.
D.Implement distributed Web services.

单项选择题You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do？（）

A.Create CHECK constraints on the tables.
B.Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
C.Create the view， specifying the WITH SCHEMABINDING option.
D.Create the view， specifying the WITH CHECK option.

多项选择题TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）

A.ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders
B.DROP TRIGGER trg InsertOrders
C.DISABLE TRIGGER trg InsertOrders ON Orders
D.ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

多项选择题You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50，000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal？（）

A.Place a nonclustered index on the date column.
B.Add a unique clustered index on the date column.
C.Map each partition to a filegroup， with each filegroup accessing a different physical drive.
D.Create a partitioning scheme that partitions the data by date.

单项选择题TestKing.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application.   You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do？（）

A.Trace the Lock：Timeout event by using SQL Server Profiler.
B.Observe the SQLServer：Locks - Number of Deadlocks/sec counter by using System Monitor.
C.Trace the Lock：Deadlock event by using SQL Server Profiler.
D.Trace the Lock：Deadlock Chain event by using SQL Server Profiler.