In configuring the thesaurus configuration file

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

(Continued from previous question...)

In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?

Answer
It means the sets in this file are accent sensitive.

Explanation
The diacritics_sensitive determines if the terms in the expansion and replacement sets are accent sensitive. A value of 0 means accent insensitive and a value of 1 means accent sensitive.

(Continued on next question...)

Other Job Interview Questions

• You are building an application for a Smartphone and want to use SQL Server Compact Edition. However you do not want this to run as a service all the time because of power concerns. What can you do?
• What does this WHERE clause evaluate to?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
• What does a report model provide in SQL Server 2005 Reporting Services?
• 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?
• What type of connectivity does the readpipe/makepipe utility test?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?
• When the network service built-in account connects to a network resource, what is the context?
• More...