Can you use Full-text search to index this colum

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

(Continued from previous question...)

Can you use Full-text search to index this column?

In SQL Server 2005, you are looking to implement full-text search. One of the tables you are looking to index stores Mircrosoft Word documents in a varbinary(max) column. Can you use Full-text search to index this column?

Answer
Yes
Explanation
You can use full-text search for formatted data such as Word that contains text stored in a varbinary column.

(Continued on next question...)

Other Job Interview Questions

• Which query will return a list of the synonyms in your database?
• A certificate is which type of security mechanism?
• What does @@textsize return?
• What value should you use for the BROKER_INSTANCE parameter?
• What T-SQL function can achieve this?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• What will be the result of the last SELECT statement if you execute the T-SQL script below as a sysadmin
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• What is row versioning in SQL Server 2005?
• Which of the following statements best describes the filter capabilities of Report Builder?
• More...