(Continued from previous part...)

When creating a full-text index on a BLOB column (image, binary or varbinary) where a file is stored, what happens if an incorrect file prefix is stored in the type column? (For instance: if a word document is stored in the image or a varbinary(MAX) column and the value of the type column is '.pdf'.

Answer The row is not full-text indexed and an error message is written to the SQL Server Error Log
Explanation The answer is the row is not full-text indexed and an error message is written to the SQL Server Error Log. No columns in the row are full-text indexed and an error message is written to the SQL Server Error Log.

In SQL Server 2005 Full-Text Search, you set up a replacement set like this:
<replacement>
<pat>SS2K5 </pat>
_{SQL Server 2005}
_{SQL Server 2K5}
</replacement>
A search for "SS2K5" doesn't return results with fields that you know contain "SS2K5". What is wrong?

The replacement set does not return results with the search terms, only the specified replacements.

In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?

Answer
Expansion sets are synonyms for the search term and returned as results if they appear along with the search term.
Explanation
The expansion set is the group of values that are synonyms and can be substituted for the search term. For example, an expansion set can be "SS2K5", "SQL Server 2005", "SQL2K5". In this case, fields with any of these 3 values would be returned as a result for searches on "SQL Server 2005".

You are initiating a new replication subscription for one of the remote offices, but don't want to transfer it across the network. The snapshot files are 725MB, too large for your CD burner and there is no tape drive at the remote office. What feature of SQL Server 2005 would help you get the snapshot transferred?

Answer
Compressed Snapshots
Explanation
In SQL Server 2005, you can specify a snapshot to be compressed and it will be compressed using the CAB format. If it compresses enough, you should be able to burn it onto a CD.

The TRUSTWORTHY database property is by default?

Answer
Off

Explanation
The correct answer is off – The TRUSTWORTHY database property indicates whether the installed instance of SQL Server trusts the database such that it can reach out and perform actions outside the database. By default it is OFF such that the database to reduce certain threats that can result from attaching a database that contains potentially harmful code.

(Continued on next part...)