Full Text Searching  «Prev  Next»

Full-text Searching - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. How are full-text indexes updated?
Please select the best answer.
  A. Automatically
  B. Manually
  C. They do not need to be updated
  D. Either automatically or manually

2. Fred would like to implement full-text searching on the Comments column in the History table, defined like this:

Column Name

Datatype
HistoryID Int
ArchiveDate Smalldatetime
ArchivedBy Varchar(30)
Comments Int

Please select the best answer.
  A. What happens when he defines the full-text index?
  B. The index is created. He only needs to add the Comments column to the full-text index and no errors are expected.
  C. The index is created. Nothing else needs to be done.
  D. The index is not created.

3. Which command would you use to retrieve data in the WHERE clause that allows you to be less precise in your search?
Please select the best answer.
  A. FREETEXT
  B. FREETEXTTABLE
  C. CONTAINS
  D. CONTAINSTABLE

4. What system stored procedure must you execute before you can create the full-text catalog by using the sp_fulltext_catalog system stored procedure?
Please select the best answer.
  A. sp_fulltext_service
  B. sp_fulltext_database
  C. sp_fulltext_table
  D. sp_fulltext_column

5. How can you use the Key column that is returned from the FREETEXTTABLE and CONTAINSTABLE commands?
Please select the best answer.
  A. You can only return the value to the browser.
  B. You can use it to return the name of the column(s) that make up the primary key.
  C. It is for internal purposes only.
  D. You can use it’s value to join with the column(s) that make up the primary key.

Score =
Correct answers: