You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view.
What should you do？（）

单项选择题You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do？（）

A.Implement a stored procedure that writes data about schema changes to a log table.
B.Implement DDL AFTER triggers that write user and schema information to a log table.
C.Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.
D.Implement a DML AFTER trigger that writes data about schema changes to a log table.

单项选择题YouareresponsibleformanagingaSQLServer2005databasethatstoressalesinformation.Manyvaluesinncharcolumnsinthedatabasetablescontainprecedingortrailingspaces.Youneedtoimplementamechanismthatselectsthedatafromthetableswithoutleadingandtrailingspaces.YoursolutionmustbeavailableforreuseinTransact-SQLstatementsandviews. Whatshouldyoudo？（）

A.Create DML triggers that query the inserted and deleted tables.
B.Create a stored procedure that calls the LTRIM and RTRIM built-in functions.
C.Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.
D.Call the TRIM built-in function.

多项选择题TestKing.com 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.

单项选择题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？（）

A.Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
B.Define the new column as NOT NULL with a default value of ’Undefined.’
C.Define the new column as NULL. Use application logic to enforce the data constraint.
D.Define the new column as NULL with a default value of ’Undefined.’

单项选择题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.