Question 14


Answer C is correct. An upgraded database with default or dbo ownership will fall into the dbo schema when upgraded to SQL Server 2005.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "Installing SQL Server, Upgrading to SQL Server 2005"

  • "An Overview of SQL Server 2005 for the Database Developer," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_ovyukondev.asp

  • "SQL Server 2005 Upgrade Handbook," www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

  • Within Microsoft Technet, go to TechNet Home, Products and Technologies, SQL TechCenter Home, SQL Server 2005, SQL Server 2005 Upgrade Handbook.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net