To which versions of SQL Server 2005 can you upg

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

(Continued from previous question...)

To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?

Answer: Any SQL Server 2005 Edition.
Explanation: You can upgrade to any SQL Server 2005 edition from SQL Server 2000 MSDE. This isn't a great question, so it's being discounted. The database format is the same in all editions, so you can move easily to any SS2K5 version.

(Continued on next question...)

Other Job Interview Questions

• How many Service Packs will be released for SQL Server 2005 in 2007?
• In Service Broker for SQL Server 2005, you encounter the following setting in one of your queues...
• What rights does a user need to perform a truncate table command SQL Server 2005?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• How can you determine which Service Broker ports are being used on your server?
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• What is the recommended way to send mail from SQLAgent in SQL Server 2005?
• What will be the result of the last SELECT statement if you execute the T-SQL script below as a sysadmin
• More...