一起答
单选

已知一个关系数据库的模式如下:market(mno,mname,city)、item(ino,iname, type,color)、sales(mno,ino,price),其中,market表示商场,它的各属性依次为商场号、商场名和所在城市;item表示商品,它的各属性依次为商品号、商品名、商品类别和颜色; sales表示销售,它的各属性依次为商场号、商品号和售价。

 查询长沙每个商场都销售,且售价均超过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
参考答案
查看试卷详情
相关试题
  1. (78)

    • A.that
    • B.what
    • C.which
    • D.those
  2. (75)

    • A.and
    • B.however
    • C.but
    • D.therefore
  3. (77)

    • A.W/S
    • B.S/C
    • C.B/S
    • D.C/S
  4. (76)

    • A.that
    • B.which
    • C.where
    • D.whit which
  5.   Remote administration types are an example of one kind of(71)malicious software, the Trojan horse, or more simply Trojan. The purpose of these programs isn't replication,(72)to penetrate and control. That masquerade as one thing when in fact they are something else, usually something destructive. There are a number of kinds of Trojans, including spybots, (73) report on the Web sites a computer user visits, and keybots or keyloggers, which record and report the user's keystrokes in order to discover passwords and other confidential information.

     RATS attempt to give a remote intruder administrative control of an infected computer. They work as(74)pairs. The server resides on the infected machine, while the client resides elsewhere, across the network, where it's available to a remote intruder. Using standard TCP/IP or UDP protocols, the client sends instructions to the server. The server does(75) it's told to do on the infected computer.

    • A.nonviral
    • B.unviral
    • C.inviral
    • D.abviral
  6. (73)

    • A.20
    • B.10
    • C.24
    • D.25
  7. (72)

    • A.20
    • B.10
    • C.24
    • D.12
  8. (70)

    • A.减少寄存器
    • B.增加寻址方式
    • C.限制访问内存
    • D.增加通道
  9. 现需要一个32M×8规格的存储器,现只有规格为1M×8的存储器芯片,则需要(49)个这样的存储器芯片。存储芯片的地址长度需要(50)位,主存储器的地址长度需要(51)位。

    • A.16
    • B.18
    • C.32
    • D.8
  10. (69)

    • A.尽可能多用原有
    • B.增加
    • C.软件固化
    • D.不用