You define full-text indexing on the ProductName column in the Products table. You then execute a full-text query on the column. You specify a word that you know is present in the column, but the result set is empty. What is the most likely cause?

  1. The catalog is not populated

  2. You did not create a unique SQL Server index on the ProductName column

  3. The SQL ServerAgent Service is not running

  4. The Microsoft Service is not running


Correct Option: A

Find more quizzes: