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

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

Please select the best answer.

What happens when he defines the full-text index?

The index is created. He only needs to add the Comments column to the full-text index and no errors are expected.

The index is created. Nothing else needs to be done.

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 must already exist before you can successfully run CREATE FULLTEXT INDEX on a table? Please select the best answer.
	A.	The table must first be enabled for full-text searching with sp_fulltext_table
	B.	A full-text catalog, named explicitly or marked AS DEFAULT
	C.	The database must first be enabled for full-text searching with sp_fulltext_database
	D.	The SQL Server Full-Text Filter Daemon Launcher service must be stopped

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.