多项选择题
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. -
单项选择题
You use a SQL Server 2005 database named DB1， which is located on a server named SQL1. DB1 is in use 24 hours a day， 7 days a week. A recent copy of DB1 exists on a second server named SQLtest that also runs SQL Server 2005. You detect a high number of full scans on SQL1 and conclude that additional indexes in DB1 are needed. A workload file that is suitable for Database Engine Tuning Advisor （DTA） already exists. You need to analyze the workload file by using DTA. You must ensure maximum performance on SQL1 during analysis. You must also ensure availability during the implementation of any recommendations suggested by the DTA. What should you do？（）
A.Store the workload file on SQL1. Start DTA on SQLtest and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box， select the Generate only online recommendations check box.
B.Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box,select the generate only online recommendations check box.
C.Store the workload file on SQL1. Start DTA on SQL1 and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box，select the All recommendations are offline check box.
D.Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest.Specify all workload and tuning options as necessary.In the Advanced Tuning Options dialog box,select the All recommendations are offline check box.
