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.