5.
要列出所有病人病历号、姓名和所用的药品总价,下列的语句正确的是______。
A
SELECT 病历号,姓名,药品总价;
FROM BRDA,MXB;
GROUP BY 病历号
B
SELECT BRDA.病历号,BRDA.姓名,SUM(MXB.数量 * MXB.单价)AS药品总价;
FROM BRDA INNER JOIN MXB;
WHERE BRDA.病历号=MXB.病历号;
GROUP BY BRDA.病历号
C
SELECT BRDA.病历号,BRDA.姓名,SUM(MXB.数量 * MXB.单价)AS 药品总价;
FROM BRDA INNER JOIN MXB;
ON BRDA.病历号=MXB.病历号;
GROUP BY BRDA.病历号
D
SELECT BRDA.病历号,BRDA.姓名,SUM(MXB.数量 * MXB.单价)AS 药品总价;
FROM BRDA INNER JOIN MXB;
ON BRDA.病历号=MXB.病历号;
ORDER BY BRDA.病历号
6.
要给BRDA表的性别字段设置一个字段级有效性规则,规则为该字段只能输入“男”或“女”,如果在输入时违反了该规则,将给出提示信息“性别必须是男或女。”正确的语句是______。
A
CREATE TABLE BRDA 性别 CHECK 性别=男 OR 性别=女;
ERROR"性别必须是男或女。"
B
ALTER TABLE BRDA ALTER 性别;
ADD CHECK 性别="男"OR 性别="女"ERROR"性别必须是男或女。"
C
ALTER TABLE BRDA ALTER 性别;
SET CHECK 性别="男"OR 性别="女"ERROR"性别必须是男或女。"
D
ALTER TABLE BRDA ALTER 性别;
SET CHECK 性别=男 OR 性别=女 ERROR"性别必须是男或女。"
7.
把MXB中药品编号为“0001”的药品的单价提高15%,其他药品的单价提高10%,以下正确的语句为______。
A
REPLACE 单价 WITH 单价*(1+0.15);
WHILE 药品编号="0001",单价 WITH 单价*(1+0.10)FOR MXB
B
UPDATE MXB 单价 WITH 单价*(1+0.15);
FOR 药品编号="0001",单价 WITH 单价*(1+0.10)
D
UPDATE MXB SET 单价 WITH IIF(药品编号子="0001",单价*(1+0.15);
单价*(1+0.10))
8.
要给BRDA表增加一个婚否字段(逻辑型),下面正确的是______。
10.
根据MXB创建一个名为YP的视图,该视图包含每种药品的药品号和销售总价,下列正确的语句是______。
A
SELECT 药品编号,SUM(数量*单价) AS 销售总价;
FROM MXB INTO VIEW YP
B
CREATE VIEW YP AS;
SELECT 药品编号,SUM(数量*单价) AS 销售总价;
FROM MXB;
GROUP BY 药品编号
C
CREATE VIEW YP AS;
SELECT 药品编号,SUM(数量*单价) AS 销售总价;
FROM MXB;
ORDER BY 药品编号
D
CREATE YP AS VIEW;
SELECT 药品编号,SUM(数量*单价) AS 销售总价;
FROM MXB;
ORDER BY 药品编号