Can a deterministic computed column be full-text

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

(Continued from previous question...)

Can a deterministic computed column be full-text indexed in SQL Server 2005? Submitted by Matija Lah

Answer: Yes

Explanation: Yes. While full-text indexes are not supported on deterministic computed columns in SQL 2000, this limitation no longer exists in SQL 2005. You cannot index non-deterministic and imprecise computed columns.

(Continued on next question...)

Other Job Interview Questions

• What will occur with the following code in SQL Server 2005 if executed by Alice?
• What does this code return? select 6 | 7 Figure it out without running it.
• Which types of replication work with Oracle publishers?
• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• You want to partition these past orders columns into a new table. What type of partitioning is this?
• How can you ensure they do not change the underlying tables without also changing the view and not disrupt their workflow?
• Which of the following columns can be indexed with SQL Server 2005 Full-Text Search?
• 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?
• Which utility is used to administer SQL Server 2005 Notification Services instances?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• More...