多项选择题
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.
相关考题
-
单项选择题
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. -
单项选择题
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.
