PrepAway - Latest Free Exam Questions & Answers

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.)

PrepAway - Latest Free Exam Questions & Answers

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