Multiple choice sql-server

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
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Full-text indexes in SQL Server must be populated (crawled) before they return results. If the index is defined but the catalog hasn't been populated with the actual data from the columns, queries will return empty results even if the search terms exist.

Keep practicing — related questions