In Full-Text Search, what is word breaking?

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

(Continued from previous question...)

In Full-Text Search, what is word breaking?

Answer
Determining word boundaries.
Explanation
Word breaking involves finding the boundaries of a word. This is different for different languages and SQL Server 2005 includes word breakers for 23 languanges.

(Continued on next question...)

Other Job Interview Questions

• Which commands are allowed when the "Ad Hoc Distributed Queries" server option is set to 0 in SQL Server 2005?
• Which is larger in size in SQL Server 2005 if you are using symmetric keys?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• Which types of replication work with Oracle publishers?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?
• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• To recover an instance of Notification Services in 2005 on another server, what information would you need?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• More...