A.待机模式
B.完全监控模式
C.部分监控模式
D.目视行车模式
第2题
A. DELETE Age from S
B. ALTER TABLE S DROP Age
C. UPDATE S Age
D. ALTER TABLE S ‘Age’
第3题
A.2.5Mbit/s
B.25Mbit/s
C.2.5Gbit/s
D.25Gbit/s
第4题
查询长沙每个商场都销售,且售价均超过3000元的商品的商品号和商品名的SQL语句为:
SELECT ino, iname FROM item
WHERE (24)
(SELECT* FROM market
WHERE (25) AND NOT EXISTS
(SELECT*FROM sales
WHERE (26) AND price>3000))
查询在不同的商场中最高售价和最低售价之差超过100元的商品的商品号、其最高售价和最低售价的SQL语句为:
SELECT ino, MAX(price), MIN(price)FROM sales
(27) HAVING MAX(price)-MIN(price)>100
A.EXISTS
B.NOTEXISTS
C.IN
D.NOTIN
第5题
SELECT Sno
FROMSP SPX
WHERE (37)
(SELECT*
FROM SP SPY
WHERE (38) ANDNOTEXISTS
(SELECT*
FROM SP SPZ
WHERE (39)));
A.EXISTS
B.NOTEXISTS
C.IN
D.NOT IN
第6题
SELECT Sno
FROM SP SPX
WHERE (1)
(SELECT*
FROM SP SPY
WHERE (2) AND NOT EXISTS
(SELECT*
FROM SP SPZ
WHERE (3)));
A.EXISTS
B.NOT EXISTS
C.IN
D.NOT IN
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!