You are employed as a database administrator at Hi-tech Company. Your duties at Hi-tech Company encompass administrating a SQL Server 2005 database named Datebase01. The Hi- tech Company 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 Datebase01 to store the comments in the Comments column of a table named TBContent. 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.