Question 6


Answer C is correct. You are probably not ordering the data to achieve the desired results. Grouping of the result set doesn't seem to be warranted because the question is asking for five rows. NULL values should not affect this query, although in some instances, NULL data can interfere with the results.

For more information, see the following sources:

  • Chapter 3, "Implementing Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Accessing and Changing Database Data, Query Fundamentals, Grouping Rows, Sorting Rows with Order By"

  • "Accessing and Changing Relational Data Overview," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_oview_4pcx.asp

  • Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, Writing SQL Queries: Let's Start with the Basics.




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