题目内容
（请给出正确答案）
A、ALTER TABLE checklist ADD PRIMARY KEY (cno)
B、ALTER TABLE checklist ALTER cno set PRIMARY KEY
C、ALTER TABLE checklist ALTER PRIMARY KEY (cno)
D、ALTER TABLE checklist ADD cno PRIMARY KEY
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
更多“在体检登记checklistlist中，为保健号增加主键约束使用的语句为（）：”相关的问题
B、3岁以上儿童每年健康检查1次，每年进行1次血红蛋白检测，1～3岁每年进行1次听力筛查，4岁以上儿童每年检查1次视力
C、儿童离园3个月以上需重新按照入园检查项目进行健康检查，“儿童转园健康证明”有效期3个月
D、体检结束后将体检表存档即可
A—physical check-up
B--biological clock
C—pulse rate
D一high blood pressure
E—sleep habits
F—over-the-counter(OTC)medicine
G—side effect
H—personality test
I—operating room
J—sense of well-being
K—face-lift
L—compulsive over-eating
M—stress self-test
N—plastic surgeon
O—heart beat.
P—behavior. therapy
Q—terminal stage
Examples： (K)面部整容 (N)整形外科医牛
36.( )心跳( )非处方药
37.( )手术室( )强迫性过度饮食
38.( )副作用( )生物钟
39.( )高血压( )脉搏率
40.( )睡眠习惯 ( )体检
A、ALTER TABLE checklist ADD cname not null
B、ALTER TABLE checklist Alter cname not null
C、ALTER TABLE checklist ADD cname set not null
D、ALTER TABLE checklist Alter cname set not null
A、SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) DESC
B、SELECT DNO,SUM() as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) ASC
C、SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) ASC
D、SELECT DNO,SUM() as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) DESC
A、SELECT dno, count(*) as 人数 FROM generalitem WHERE gtjrq>=’2018-01-01’ and gtjrq<’2018-07-01’ group by> B、SELECT dno,sum() as 人数 FROM generalitem WHERE between '2018-01-01' and '2018-06-30' GROUP BY dno
C、SELECT dno,count(*) as 人数 FROM generalitem GROUP BY dno where gtjrq>=’2018-01-01’ and gtjrq<’2018-07-01’<br> D、SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno where between '2018-01-01' and '2018-06-30'
警告：系统检测到您的账号存在安全风险
为了保护您的账号安全，请在“简答题”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！
