Question 5

Answer D is correct. Dates are inclusive with the BETWEEN function. Be careful when using comparisons that might rely on the time elements of the data because improperly formulating a condition could exclude some desired data.

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, Filtering Rows by Using Where and Having, Range Search Conditions"

• "Expressions in Queries," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdtsql/dvovrusingexpressionsinqueries.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.