PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

Domain.com 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.

Explanation:
Although you create full-text indexes on columns within tables in SQL databases, the full-text indexes are maintained in a structure outside of SQL Server called a full-text catalog. A full-text catalog can contain one or more full-text indexes.


Leave a Reply