Question 29

Answers D and E are correct. GETDATE is a nondeterministic function that would not be allowed if you intended to create indexes in the views. The presence of any date fields or deterministic functions would not be problematic.

For more information, see the following sources:

• Chapter 3, "Implementing Database Objects"

• SQL Server 2005 Books Online: "SQL Server Database Engine, Designing and Creating Databases, User-defined Functions (Database Engine), Designing User-defined Functions, Deterministic and Nondeterministic Functions"

• "Creating Indexed Views," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdtsql/dvtskcreatingindexedviews.asp

• "Designing an Indexed View," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_06_6ptj.asp