多項(xiàng)選擇題

TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view.
Which two actions should you perform？（）

A.Remove all deterministic function calls from within the view.
B.Remove all nondeterministic function calls from within the view.
C.Schema-bind all functions that are called from within the view.
D.Create the view and specify the WITH CHECK OPTION clause.

你可能感興趣的試題

單項(xiàng)選擇題

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？（）

A.Update the view to use an outer join between the Customers and Sales tables.
B.Create a clustered index on the v CustomerSales view.
C.Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
D.Create a stored procedure for the business analysts that uses the v CustomerSales view.

單項(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.

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

你可能感興趣的試題

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