You are employed as a database administrator at Domain.com. Your duties at Domain.com encompass administrating a SQL Server 2005 database named Certkiller -DB03.
The Domain.com Web site has a page for clients to send the comments about its products and the company. You received instruction from the CIO to use Certkiller -DB03 to store the comments in the Comments column of a table named CKFeedback. You implement full-text searching in order to run reports on the comments.
What actions should you execute? (Choose all that apply)
A.
You need to execute the USE Master Transact-SQL statement.
B.
You need to create a full-text indexed on the Comments column.
C.
You need to ensure that a full-text catalog is created.
D.
You need to create a nonclustered 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.