多项选择题
Your company Web site includes a page that customers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback. You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform? ()
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. -
多项选择题
YourcompanyusesSQLServer2005.Usersreportthatreportexecutionisslow.Youinvestigateanddiscoverthatsomequeriesdonotuseoptimalexecutionplans.Youalsonoticethatsomeoptimizerstatisticsaremissingandothersareoutofdate.Youneedtocorrecttheproblemsothatreportsexecutemorequickly.WhichtwoTransact-SQLstatementsshouldyouuse?()
A. DBCC CHECKTABLE
B. ALTER INDEX REORGANIZE
C. UPDATE STATISTICS
D. CREATE STATISTICS
E. DBCC SHOW_STATISTICS
F. DBCC UPDATEUSAGE
