多項選擇題

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.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线