Question 27


Answer A is correct. A default constraint supplies a column with an initial value that can be changed whenever needed. When you load a row into a table with a DEFAULT definition for a column, you implicitly instruct the engine to insert a default value in the column when a value is not specified for it, but still allow for a value to be entered.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Designing and Creating Databases, Tables, Designing Tables, Enforcing Data Integrity"

  • "ALTER TABLE," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.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

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