已知关系SPJ(S#,P#,J#,QTY),把对关系SPJ的属性QTY的修改权授予用户张三的T-SQL语句是()
第1题:
A.GRANT QTY ON SPJ TO 张三
B.GRANT UPDATE ON SPJ TO张三
C.GRANT UPDATE (QTY) ON SPJ TO张三
D.GRANT UPDATE ON SPJ (QTY) TO张三
第2题:
现在有两个关系模式:供应商S(Sno,Sname,Status,City)和供应情况SPJ(Sno,Pno,Jno, Qty)。对于查询“查询零件号Pno等于‘P3’的供应商名Sname”SQL语句(221)是错误的,而关系代数表达式(222)是正确的。
A.SELECTSname FROM S WHERE EXIST5(SELECT * FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
B.SELECT Sname FROM S,SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3') CROUP BY Sname
C.SELECT DISTINCT Sname FROM S WHERE EXISTS(SELECT * FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
D.SELECT DISTINCT Sname FROM S WHERERE 0<(SELECTCOUNT(,) FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pnn='P3')
第3题:
●假设供应商S和供应情况SPJ的关系模式分别为S(Sno,Sname,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL语句 (19) 不能正确地查询出"零件号Pno等于'P3'的供应商名Sname",而 (20) 能正确查询的关系代数表达式。
(19) A.SELECT DISTINCT Sname
FROMS
WHERE EXISTS
(SELECT*
FROM SPJ
WHERE S.Sno=SPJ.SnO
AND SPJ.Pno=′P3′
B.SELECT DISTmCT Sname
FROMS
WHERE 0<
(SEIECT COUNT(*)
FROM SPJ
WHERE S.Sno=SPJ.Sno
AND SPJ.Pno=′P3′)
C.SELECT Sname
FROMS
WHERE EXISTS
(SELECT*
FROM SPJ
WHERE S.Sno=SPJ.Sno
AND SPJ.Pno=′P3′)
D.SELECT Sname
FROMS,SPJ
WHERES.Sno=SPJ.Sno
AND SPJ.Pno=′P3′)
GROUP BYSname
(20) A.Πsname(S)Dσ 0 Pno=′P3′(SPJ)
B.Πsname(SD∞σ Pno=′P3′(SPJ))
C.Πsname(S)-Πsname(σ Pno≠′P3′(Sσσ(SPJ)
D.Πsname(S)-Πsname((S∞σ Pno≠′P3′(SPJ)
第4题:
假设供应商S和供应情况SPJ的关系模式分别为S(Sno,Snaale,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL。语句(19)不能正确地查询出“零件号Pno等于‘P3’的供应商名Snam”,而(20)能正确查询的关系代数表达式。
A.SELECT DISTINCTSname
B.SELECT DISTm CTSname FROMS FROMS WHERE EXISTS WHERE 0<(SELECT*(SELECTCOUNT(*)FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHERE S.Sno;SPJ.Sno AND SPJ.Pno;
C.SELECT Shame
D.SELECT Sname FROMS FROMS,SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno(SELECT* ANDSPJ.Pno='P3')FROM SPJ GROUP BYSname WHERE S. Sno=SPJ. Sno
第5题:
假设供应商S和供应情况SPJ的关系模式分别为:S(Sno,Sname,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL语句(22)不能正确地查询出“零件号Pno等于‘P3’的供应商名Sname",而(23).能正确查询的关系代数表达式。
A.SELECT DISTINCT Sname
B.SELECT DISTmCT Sname FROMS FROMS WHERE EXISTS WHERE 0<(SELECT *(SEIECT COUNT(*)FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHERE
C.SELECT Sname
D.SELECT Sname FROMS FROMS, SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno(SELECT * AND SPJ.Pno= 'P3')FROM SPJ GROUP BYSname W
第6题:
假设供应商S和供应情况SPJ的关系模式分别为:S(Sno, Sname, Status, City)和SPJ(Sno, Pno, Jno, Qty)。SQL语句______不能正确地查询出“零件号Pno等于'P3'的供应商名Sname”。
A.SELECT DISTINCT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
B.SELECT DISTINCT Sname FROM S WHERERE 0< (SELECT COUNT (*) FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
C.SELECT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')
D.SELECT Sname FROM S, SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3') GROUP BY Sname
第7题:
假设供应商S和供应情况SPJ的关系模式分别为S(Sno,Sname,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL语句(25)不能正确地查询出“零件号Pno等于'P3'的供应商名Sname",而(26)能正确查询的关系代数表达式。
A.SELECT DISTINCT Sname FROM S WHERERE 0 <(SELECT COUNT( *)FROM SPJ WHERE S. Sno = SPJ. Sno AND SPJ. Pno = 'P3')
B.SELECT DISTINCT Sname FROM S WHERE EXISTS(SELECT * FROM SPJ WHERE S. Sno=SPJ. Sno AND SPJ. Pno= 'P3')
C.SELECT Sname FROM S WHERE EXISTS( SELECT * FROM SPJ WHERE S. Sno = SPJ. Sno AND SPJ. Pno = 'P3')
D.SELECT Sname FROM S, SPJ WHERE S. Sno = SPJ. Sno AND SPJ. Pno = 'P3' GROUP BY Sname
第8题:
阅读以下说明,回答问题1至问题3,将解答写在对应栏内。
【说明】
有如下关系数据库:
S(SNO,SN,STATUS,CITY)
P(PNO,PN,COLORS,WEIGHT)
J(JNO,JN,CITY)
SPJ(SNO,PNO,JNO,QTY)
其中,S为供应单位,P为零件,J为工程项目,SPJ为工程订购零件的订单,其语义为:某供应单位供应某种零件给某个工程,请用SQL完成下列操作。
求为工程J1提供红色零件的供应商代号。
第9题:
设有一个SPJ数据库,包括S,P,J,SPJ 4个关系模式: S(SNO,SNAME,STATUS,CITY): P(PNO,PNAME,COLOR,WEIGHT): J(JNO,JNAME,CITY): SPJ(SNO,PNO,JNO,QTY): 供应商表S由供应商代码(SNO)、供应商姓名(SNAME)、供应商状态(STATUS)、供应商所在城市(CIIY)组成。 零件表P由零件代码(PNO)、零件名(PNAME)、颜色(COLOR)、重量(WEIGH)组成。 工程项目表J由工程项目代码(JNO)、工程项目名(JNAME)、工程项目所在城市(CITY)组成。 供应情况表SPJ由供应商代码(SNO)、每件代码(PNO)、工程项目代码(JNO)、供应数量(QTY)组成,表示某供应商供应某种零件给某工程项目的数量OTY。 那么用关系代数完成查询“供应工程J1红色零件的供应商号SNO”,应是(44)。
A.πSNO(πSNO,PNO(σJNO='J1'(S))×πPNO(σCOLOR='红'(P)))
B.πSNO(πSNO,PNO(σJNO='J1'(S))πPNO(σCOLOR='红'(SPJ)))
C.πSNO(πSNO,PNO(σJNO='J1'(SPJ))πPNO(σCOLOR='红'(P)))
D.πSNO(πSNO,PNO(σJNO='J1'(SPJ))×πPNO(σCOLOR='红'(P)))
第10题:
设销售数据模型如下:
厂家S(SNO,SNAME,CITY)
产品P(PNO,PNAME,COLOR,WEIGHT)
销售SPJ(SNO,PNO,QTY)
用SQL完成以下操作:
PNO为“007”的产品数增加1500;并检索出其对应的产品名.