What should you do?

You are work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Your duties at Domain.com include administrating Certkiller -DB01.
Domain.com has a Web site that has a page for customers to send feedback about Domain.com’s products. You use a database CK_Products to store the comments in the Comments column of a table named Feedback.
You want to implement full-text searching so that you can run reports on the Comments column.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)

You are work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Your duties at Domain.com include administrating Certkiller -DB01.
Domain.com has a Web site that has a page for customers to send feedback about Domain.com’s products. You use a database CK_Products to store the comments in the Comments column of a table named Feedback.
You want to implement full-text searching so that you can run reports on the Comments column.
What should you do? (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.

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 0

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