Multiple choice technology databases

You have currently installed SQL Server 7.0 Standard Edition SP4 and wish to upgrade to SQL Server 2005. Which versions of SQL Server 2005 can you upgrade to?

  1. (a) SQL Server 2005 Developer Edition

  2. (b) SQL Server 2005 Enterprise Edition

  3. (c) SQL Server 2005 Standard Edition

  4. (d) SQL Server 2005 Express Edition
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

SQL Server 7.0 Standard Edition can upgrade to SQL Server 2005 Standard Edition (same tier) and Enterprise Edition (upgrade path). Developer and Express editions are lateral moves or downgrades - Microsoft doesn't support direct in-place upgrades from Standard to these editions. You would need to migrate data instead.

Keep practicing — related questions