In the SQL Server 2005 thesaurus XML configurati

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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".

(Continued on next question...)

Other Job Interview Questions

• How can you quickly determine if any of these indexes are really being used?
• What does this return?
• In SQL Server 2005, which network protocols use endpoints?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• Can a deterministic computed column be full-text indexed in SQL Server 2005? Submitted by Matija Lah
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• What What does the term ACID refer to?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• More...