YouaremodifyingatablenamedProductinaSQLServer2005database.YouwanttoaddanewcolumnnamedFriendlyNametotheProducttable.Afriendlynameforeachproductwillbestoredinthiscolumn.Thetablecurrentlycontainsdata.The salesdepartmenthasnotyetcreatedafriendlynameforeachproduct.FriendlyNameisarequiredvalueforeachproduct.Youwanttoaddthisnewcolumnbyusingtheleastamountofeffort.Whatshouldyoudo？（）A.DefinethenewcolumnasNULL.UpdatetheFriendlyNamecolumntothesamevalue astheproductNamecolumn.AltertheFriendlyNamecolumntobeNOTNULL.B.DefinethenewcolumnasNOTNULLwithadefaultvalueof’Undefined.’C.DefinethenewcolumnasNULL.Useapplicationlogictoenforcethedataconstraint.D.DefinethenewcolumnasNULLwithadefaultvalueof’Undefined.’

YouaremodifyingatablenamedProductinaSQLServer2005database.YouwanttoaddanewcolumnnamedFriendlyNametotheProducttable.Afriendlynameforeachproductwillbestoredinthiscolumn.Thetablecurrentlycontainsdata.The salesdepartmenthasnotyetcreatedafriendlynameforeachproduct.FriendlyNameisarequiredvalueforeachproduct.Youwanttoaddthisnewcolumnbyusingtheleastamountofeffort.Whatshouldyoudo？（）

A.DefinethenewcolumnasNULL.UpdatetheFriendlyNamecolumntothesamevalue astheproductNamecolumn.AltertheFriendlyNamecolumntobeNOTNULL.

B.DefinethenewcolumnasNOTNULLwithadefaultvalueof’Undefined.’

C.DefinethenewcolumnasNULL.Useapplicationlogictoenforcethedataconstraint.

D.DefinethenewcolumnasNULLwithadefaultvalueof’Undefined.’

相关考题：

上／下行时隙是否都需要触发时隙内资源调整? A．错误B．正确
查看答案
儿童发展的差异主要表现在()。 A.心理差异B.人格差异C.生理差异D.年龄差异
查看答案
YourcompanyhasasingleActiveDirectorydomainandanenterpriserootcertifficateauthority.ThecompanyplanstouseNetworkAccessProtection（NAP）toprotecttheVPNconnections.YoubuildtwoserversnamedNPS1andVPN1.Youconfigurethefollowingfunctionsonthetwoserversasshowninthefollowingtable.YouneedtoensurethatthesystemhealthpolicyisappliedtoallclientcomputersthatattemptVPNconnections.Whatshouldyoudo?（）A.ReconfigureNPS1asaradiusclientB.ReconfigureVPN1asaradiusclientC.AddtheNAProletoadomaincontrollerD.AddtheNAProletoanEnterrpiseCertificateserver.
查看答案
垫铁组每组每块垫铁间接触良好无间隙,用0.05mm塞尺检查其间隙,在垫铁同一断面处从两侧塞入长度总和,不超过垫铁宽度的()。 A、二分之一B、三分之一C、三分之二D、四分之一
查看答案
使用OutlookExpress通过选择“工具”菜单的“选项”菜单项可以()。 A.设置电子邮件保存的位置B.阻止垃圾邮件C.设置定时收取邮件D.在服务器保留邮件备份
查看答案
Which of the following is the smallest separately installable unit on an AIX system?() A.FileB.FilesetC.BundleD.Licensed program product
查看答案
在Excel2003中,要保护一个工作表,可在工具菜单中选择保护命令中的保护工作表项。 A．错误B．正确
查看答案
计算机系统中软硬件在逻辑上是等效的,提高软件功能实现的比例将会() A.提高解题速度B.提高系统灵活性C.增加成本D.减少所需存储容量
查看答案
热门标签