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

单项选择题 YouarecreatingaSQLServer2005databaseforamortgagecompany.ThedatabasewillsupportanewWeb-basedapplicationthatwillhandleupto1,000simultaneoususers.Thisapplicationmustquicklydisplaytheresultsofcalculation-intensiveoperations,suchascalculatingmortgagepaymentsandamortizationschedules.Youneedtoensurethatthedatabaseprocessescalculationsasquicklyandefficientlyaspossible.Whatshouldyoudo?（）

多项选择题 YourcompanyWebsiteincludesapagethatcustomersusetosendfeedbackaboutthecompanyanditsproducts.YouuseaSQLServer2005databasetostorethecommentsintheCommentscolumnofatablenamedFeedback.Youneedtoimplementfull-textsearchingsothatyoucanrunreportsonthecomments.Whichtwoactionsshouldyouperform?（）

单项选择题 YouareresponsibleformanagingthedatabaseschemaforanorderentryapplicationinaSQLServer2005database.Afteradesignreview,amemberofthedevelopmentstaffasksyoutoaddanewcolumnnamedCommissionRatetotheProducttable.Becausetheactualcommissionratesforallproductsarenotknownatthistime,eachproducthasadefaultcommissionrateof12percent.Theratecanbemodifiedasnecessary.Youaddthenewcolumn.Youneedtoconfigurethetabletoassignthedefaultvalueasefficientlyaspossible.Whatshouldyoudo?（）

MCITP(70-431)