皮皮学，免费搜题
登录
搜题
【单选题】
You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review， a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time， each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do？（）A.
Create an INSERT trigger to assign the default value to each item in the table.
B.
Create a CHECK constraint to validate the data and to assign the default value to each item in the table.
C.
Create an UPDATE trigger to update the default value for each new item in the table.
D.
Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【单选题】The product was inspected and quarantined by the competent authority, in accordance ( the relevant regulations.
A.
on
B.
to
C.
for
D.
with
【简答题】A．intelt B．competitive C．capable D．competent
【单选题】The competent educational research ______.
A.
does not have the same standards with competent scientific research
B.
is a part-time activity of education
C.
should have standards which require different duties
D.
produces the same influence with scientific research
【多选题】从形态和功能上可将人的机体划分为运动系统、消化系统、呼吸系统、泌尿系统、生殖系统、循环系统、内分泌系统、感觉系统和神经系统共九个子系统。在人机系统中,人与机的沟通主要是通过( )。
A.
对对象目的、任务理解
B.
注意对象设计欠佳
C.
注意对象设计欠佳
D.
注意对象设计欠佳
E.
对对象有间接兴趣
【简答题】网络安全完整性的主要防范措施是____与____。
相关题目：
参考解析：
知识点：
题目纠错 0
发布
