What should you do?

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?

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]



Leave a Reply 0

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