当前位置:MCITP(70-431)题库

问题:

[多选]

Your company 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 
E .  sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'

请人赴约说(),对方来信说(),自己住家说()。 液化石油气气体密度通常随着温度及相应饱和蒸气压的升高而()。 减小。 不变。 增加。 In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories.  Which optioncorresponds to the type of activities you performed() Oracle Managed Files。 Oracle Grid Architecture。 Optimal Flexible Architecture。 Oracle database architecture。 Automatic Storage Management。 清白队伍控制组 Which two APIs are published by IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server?() Data Mining API。 Provisioning API。 Cryptography API。 API for Second Factors。 SOAP API for Mobile ActiveCode。

Your company 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?()

参考答案:

  参考解析

本题暂无解析

在线 客服