_ an order for 100 pieces or more, we allow a special discount of 5% for payment by L/C.A.
_ an order for 100 pieces or more, we allow a special discount of 5% for payment by L/C.
A.At
B.In
C.On
D.From
_ an order for 100 pieces or more, we allow a special discount of 5% for payment by L/C.
A.At
B.In
C.On
D.From
第1题
(37)
A. 零件号,零件名称
B. 零件号,供应商
C. 零件号,供应商所在地
D. 供应商,供应商所在地
(38)
A. P1(零件号,零件名称,单价) 、P2(供应商,供应商所在地,库存量)
B. P1(零件号,零件名称) 、P2(供应商,供应商所在地,单价,库存量)
C. P1(零件号,零件名称) 、P2(零件号,供应商,单价,库存量)、P3(供应商,供应商所在地)
D. P1(零件号,零件名称)、P2(零件号,单价,库存量)、P3(供应商,供应商所在地)、P4(供应商所在地,库存量)
对零件关系P,查询各种零件的平均单价、最高单价与最低单价之间差价的SQL语句为:
SELECT 零件号, (39)
FROM P
(40) ;
(39)
A. 零件名称,AVG(单价),MAX(单价)? MIN(单价)
B. 供应商,AVG(单价),MAX(单价)? MIN(单价)
C. 零件名称,AVG 单价,MAX 单价? MIN 单价
D. 供应商,AVG 单价,MAX 单价 ? MIN 单价
(40)
A. ORDER BY 供应商
B. ORDER BY 零件号
C. GROUP BY 供应商
D. GROUP BY 零件号
对零件关系 P,查询库存量大于等于 100 小于等于 500 的零件“P1”的供应商及库存量,要求供应商地址包含“西安” 。实现该查询的SQL语句为:
SELECT 零件名称,供应商名,库存量
FROM P
WHERE (41) AND (42) ;
(41)
A. 零件名称= 'P1' AND库存量Between 100 AND 500
B. 零件名称= 'P1' AND库存量Between 100 TO 500
C. 零件名称= 'P1' OR库存量Between 100 AND 500
D. 零件名称= 'P1' OR库存量Between 100 TO 500
(42)
A. 供应商所在地in '%西安%'
B. 供应商所在地like '__西安%'
C. 供应商所在地like '%西安%'
D. 供应商所在地like '西安%'
第2题
A.$2,250
B.$2,517
C.$3,204
D.$5,454
第3题
A.SELECT PNAME FROM P WHERE COLOR IN (‘红’, ‘蓝’) ORDER BY WEIGHT ASC;
B.SELECT PNAME FROM P WHERE COLOR = ‘红’ AND COLOR = ‘蓝’ ORDER BY WEIGHT ASC;
C.SELECT PNAME FROM P WHERE COLOR IN (‘红’, ‘蓝’) ORDER BY WEIGHT DESC;
D.SELECT PNAME FROM P WHERE COLOR = ‘红’ OR COLOR = ‘蓝’ ORDER BY WEIGHT DESC;
第4题
--- Are you ready to order?
--- ________.
A. It’s a good idea
B. Yes. I’ll have a steak, please
C. It’s very kind of you
第5题
A.In order to help you push the sales of our new product, we agree to make payment by D/P 30 days
B.In order to help you push the sales of our new product, we agree to make payment by D/P at sight 30 days
C.In order to help you push the sales of our new product, we agree to make payment by D/A 30 days
D.In order to help you push the sales of our new product, we agree to make payment by D/A at sight 30 days
第6题
A.In order to help you push the sales of our new product, we agree to make payment by D/P 30 days
B.In order to help you push the sales of our new product, we agree to make payment by D/P at sight 30 days
C.In order to help you push the sales of our new product, we agree to make payment by D/A 30 days
D.In order to help you push the sales of our new product, we agree to make payment by D/A at sight 30 days
第7题
此题为判断题(对,错)。
第8题
A.In order to help you push the sales of our new product, we agree to make payment by D/P 30 days
B.In order to help you push the sales of our new product, we agree to make payment by D/P at sight 30 days
C.In order to help you push the sales of our new product, we agree to make payment by D/A 30 days
D.In order to help you push the sales of our new product, we agree to make payment by D/A at sight 30 days
第9题
A . P
B . Q
C . R
D . S
E . T
第10题
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!