网友您好, 请在下方输入框内输入要搜索的题目:
YouaremodifyingatablenamedProductinaSQLServer2005database.YouwanttoaddanewcolumnnamedFriendlyNametotheProducttable.Afriendlynameforeachproductwillbestoredinthiscolumn.Thetablecurrentlycontainsdata.The salesdepartmenthasnotyetcreatedafriendlynameforeachproduct.FriendlyNameisarequiredvalueforeachproduct.Youwanttoaddthisnewcolumnbyusingtheleastamountofeffort.Whatshouldyoudo?()
A.DefinethenewcolumnasNULL.UpdatetheFriendlyNamecolumntothesamevalue astheproductNamecolumn.AltertheFriendlyNamecolumntobeNOTNULL.
B.DefinethenewcolumnasNOTNULLwithadefaultvalueof’Undefined.’
C.DefinethenewcolumnasNULL.Useapplicationlogictoenforcethedataconstraint.
D.DefinethenewcolumnasNULLwithadefaultvalueof’Undefined.’
参考答案