一起答
单选

假设供应商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             WHER
  • C.SELECT Sname
  • D.SELECT Sname              FROMS                            FROMS, SPJ                   WHERE EXISTS                   WHERES.Sno=SPJ.Sno(SELECT *                        AND SPJ.Pno= 'P3')FROM SPJ                          GROUP BYSname                  
试题出自试卷《软件水平考试(初级)网络管理员上午(基础知识)模拟试卷32》
参考答案
查看试卷详情
相关试题
  1. (102)

    • A.names
    • B.eookies
    • C.software
    • D.extensions
  2. (103)

    • A.cracker
    • B.user
    • C.customer
    • D.client
  3. (101)

    • A.memory
    • B.caehes
    • C.ports
    • D.registers
  4. (100)

    • A.virtual
    • B.virus
    • C.worms
    • D.bacteria
  5. Melissa and Love Letter made use of the trust that exists between friends or colleagues. Imagine receiving an(66)from a friend who asks you to open it. This is what happens with Melissa and several other similar email(67).Upon running, such worms usually proceed to send themselves out to email addresses from the victim' s address book ,previous emails, web pages(68).

    • As administrators seek to block dangerous email attachments through the recognition of well- known (69), virus writers use other extensions to circumvent such protection. Executable (.exe) files are renamed to . bat and . cnd plus a whole list of oth
    • A.attachment
    • B.paeket
    • C.datagram
    • D.message
  6. (97)

    • A.2位
    • B.3位
    • C.4位
    • D.8位
  7. (98)

    • A.分组装拆
    • B.网络互联
    • C.差错控制
    • D.编、译码
  8. (96)

    • A.X.28
    • B.X.75
    • C.X.25
    • D.X.29
  9. (95)

    • A.永久虚电路方式
    • B.交换虚电路方式
    • C.数据报方式
    • D.电路交换方式
  10. X.25是CCITT关于分组交换网络的通信协议,其内容包括OSI参考模型(61);分组在X.25网中的传输方式,不含(62);两个X.25公用分组网之间互连时,采用的互连协议为(63);公用分组交换网的地址(编号)根据X.121建议编制,该地址中表示国别的部分有(64)十进制数;PAD的主要功有是(65)。

    • A.最高层
    • B.下3层
    • C.低两层
    • D.最底层