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




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