Which command or commands should you use next?

You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing
application. You need to ensure that the database allows full-text searches on the
Customers table. You also need to ensure that the full-text index is ready for use by the
users.
You execute a Transact-SQL statement to create the full-text index on the Customers table
by using the CHANGE_TRACKING OFF and NO POPULATION clauses in the CREATE
FULLTEXT INDEX statement. You execute an ALTER FULLTEXT INDEX. Which command
or commands should you use next?

You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing
application. You need to ensure that the database allows full-text searches on the
Customers table. You also need to ensure that the full-text index is ready for use by the
users.
You execute a Transact-SQL statement to create the full-text index on the Customers table
by using the CHANGE_TRACKING OFF and NO POPULATION clauses in the CREATE
FULLTEXT INDEX statement. You execute an ALTER FULLTEXT INDEX. Which command
or commands should you use next?

A.
Option A

B.
Option B

C.
Option C

D.
Option D



Leave a Reply 0

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