You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01 that has two RAID-5 arrays for storing data files. Certkiller -DB01 hosts a database named CK_Products that stores data on the products sold by Domain.com.
Domain.com wants to allow prospective customers search for information in the CK_Products database via a Web-based interface. The prospective customers will use key words and phrases to search the CK_Products database. You decide to implement a Full-Text Search on the database. You install the Full-Text Search component on Certkiller -DB01 and start the Microsoft Search service. You then create the required catalog and full-text index. You modify the full-text index by running the following Transact-SQL statement:
ALTER FULLTEXT INDEX ON CK_Products.Description
ADD (shortName)
WITH NO POPULATION
Later you discover that you cannot perform full-text queries against the shortName column. You need to ensure that full-text queries can be performed against the shortName column.
What should you do?
A.
Drop and recreate the full-text index.
B.
Run the following statement:
ALTER FULLTEXT INDEX ON CK_Products.Description
ENABLE
C.
Stop and restart the SQL Server Agent.
D.
Run the following statement:
ALTER FULLTEXT INDEX ON CK_Products.Description
START FULL POPULATION
Explanation:
If the WITH NO POPULATION clause is used you add or drop a column from a full-text index, the full-text index will not be populated after the ADD or DROP column operation. The full-text index will only be populated if you run the START…POPULATION command.
Incorrect Answers:
A: The full-text queries against the shortName column failed because the index was not populated after the column was added. You can drop and recreate the full-text index but it would be easier to repopulate the index. You can run the START…POPULATION command to repopulate the index.
B: This statement enables the full-text index; however, the full-text index is enabled by default.
C: The full-text queries against the shortName column failed because the index was not populated after the column was added. Stopping and restarting the SQL Server Agent will not repopulate the full-text index.
Reference:
Microsoft SQL Server 2005 Books Online (2007), Index: ALTER FULLTEXT INDEX statement
Microsoft SQL Server 2005 Books Online (2007), Index: full-text indexes [SQL Server]