单选

假设供应商S和供应情况SPJ的关系模式分别为:S(Sno,Sname,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL语句(22)不能正确地查询出“零件号Pno等于‘P3’的供应商名Sname”,而(23)能正确查询的关系代数表达式。

  • 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       WHERES.Sno=SPJ.Sno   AND SPJ.Pno='P3')
  • C.SELECT Sname       FROMS       WHERE EXISTS(SELECT*       FROM SPJ       WHERES.Sno=SPJ.Sno       ANDSPJ.Pno='P3')
  • D.SELECT Sname       FROMS,SPJ       WHERES.Sno=SPJ.Sno       ANDSPJ.Pno='P3')GROUP BYSname
参考答案
您可能感兴趣的试题

(73)

  • A.The repeater
  • B.The modem
  • C.The hub
  • D.The printer

(72)

  • A.Token Ring
  • B.Token Bus
  • C.Ethernet
  • D.FDDI

(71)

  • A.The repeater
  • B.The hub
  • C.The bridge
  • D.The router

(70)

  • A.NetBEUI
  • B.IP
  • C.IPX
  • D.NCP

(68)

  • A.in general
  • B.in any term
  • C.in set terms
  • D.in terms of

(67)

  • A.faced on
  • B.faced with
  • C.faced about
  • D.faced up to

(66)

  • A.consolidates
  • B.consists
  • C.considerate
  • D.consoles

(65)

  • A.same
  • B.similar
  • C.different
  • D.difference
¥

订单号:

遇到问题请联系在线客服

订单号:

遇到问题请联系在线客服