Which of the following columns can be indexed wi

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

(Continued from previous question...)

Which of the following columns can be indexed with SQL Server 2005 Full-Text Search?

Answer
char, varchar, nvarchar, and varbinary, text, ntext, and image
Explanation
All character columns, char, varchar and nvarchar columns including max, text and ntext, and image columns are valid for full-text searching.

(Continued on next question...)

Other Job Interview Questions

• Which type of XML variable requires a\one and only one root element?
• The queries still seem slow immediately after snapshot creation. Why?
• Which framework would you use to manage this database programatically?
• This administrator will own the jobs. Which role should you assign?
• What does HAS_DBACCESS() do?
• With SQL Server 2005, Oracle servers can be included in your replication topology. How can an Oracle server function?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• More...