单项选择题
You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead.
What should you do？（）
A.Create CHECK constraints on the tables.
B.Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
C.Create the view， specifying the WITH SCHEMABINDING option.
D.Create the view， specifying the WITH CHECK option.
相关考题
-
多项选择题
TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）
A.ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders
B.DROP TRIGGER trg InsertOrders
C.DISABLE TRIGGER trg InsertOrders ON Orders
D.ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION -
多项选择题
You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50，000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal？（）
A.Place a nonclustered index on the date column.
B.Add a unique clustered index on the date column.
C.Map each partition to a filegroup， with each filegroup accessing a different physical drive.
D.Create a partitioning scheme that partitions the data by date. -
单项选择题
TestKing.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application. You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do？（）
A.Trace the Lock：Timeout event by using SQL Server Profiler.
B.Observe the SQLServer：Locks - Number of Deadlocks/sec counter by using System Monitor.
C.Trace the Lock：Deadlock event by using SQL Server Profiler.
D.Trace the Lock：Deadlock Chain event by using SQL Server Profiler.
