安全监控系统分站应具有如下功能:当掘进工作面或回风流中甲烷浓度()时,应对局部通风机进行闭锁使之不能启动
A. 大于 1.5 %CH。
B. 大于 3%cH
C. 小于 1.5NCH。
查看答案
要删除 Student 表的Birthyear 列,同时删除所有引用该列的视图和约束。下列哪一个SQL语句正确表达了这一删除要求()
ALTER TABLE Student DROP Birthyear RESTRICT;
B. ALTER TABLE Student DROP Birthyear RESTRICT;
C. ALTER TABLE Student DROP Birthyear RESTRICT;
D. ALTER TABLE Student. DELETE Birthyear CASCADE;
有学生选课关系 SC(S,C,GRADE ),其中 S为学号, C为课程号, GRADE 为成绩。要查找 "选修了C01号课程且成绩不低于 90分的学生的学号 ",下列哪一个 SQL语句正确表达了此查询请求()
A. SELECT S FROM SC GROUP BY C = CO1’ HAVING GRADE≥90;
B. SELECT S FROM SC GROUP BY C = 'C01’ WITtH GRADE≥90;
C. SELECT S FROM SC GROUP BYC = C01’ WITH GRADE≥90;
D. SELECT S FROM SC HAVING C = ’C01' AND GRADE ≥90;
矿用电源的交流额定输入电压,宜同时满足()和220V输入
A. 110 V
B. 127 V
C. 134 V
把对表 STUDENT 进行查找和插入的操作权限授予用户User1 ,并允许他将此权限再授予其他用户。下列哪一个 SQL语句正确表达了这一授权()
A. GRANT SELECT, INSERT ON TABLE STUDENT TO User1;
B. GRANT ALL PRIVILEGES ON TABLE STUDENT TO User1;
C. GRANT SELECT, INSERT ON TABLE STUDENT TO User1 WITH GRANT OPTION;
D. GRANT ALL PRIVII ,EGES ON TABLE STUDENT TO User1 WITH GRANT OPTION;