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