Which two actions should you perform?

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? (Each correct answer presents part of the solution. Choose two.)

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? (Each correct answer presents part of the solution. Choose two.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *