單項(xiàng)選擇題

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.

你可能感興趣的試題

單項(xiàng)選擇題

You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views.
What should you do？（）

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.

多項(xiàng)選擇題

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.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久