You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. 
What should you do?（）

多项选择题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?（）

A. Implement parameterized Transact-SQL queries in the application. 
B. Implement Transact-SQL stored procedures in the database. 
C. Implement CLR stored procedures in the database. 
D. Implement distributed Web services.

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

A. Create a nonclustered index on the Comments column. 
B. Execute the USE Master Transact-SQL statement. 
C. Create a full-text catalog. 
D. Create a full-text index on the Comments column.

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

A. Create an INSERT trigger to assign the default value to each item in the table. 
B. Create a CHECK constraint to validate the data and to assign the default value to each item in the table. 
C. Create an UPDATE trigger to update the default value for each new item in the table. 
D. Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

单项选择题YouareresponsibleforimplementingmaintenancejobsonaSQLServer2005databaseserver.CertainjobsruneverySundayandotherjobsrunatthebeginningofeverymonth.Youneedtoschedulethejobsinthewaythatusestheleastamountofadministrativeeffort.Whatshouldyoudo?（）

A. Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule. 
B. Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code. 
C. Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs. 
D. Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month.