一起答
单选

结构化查询语言SQL是一种(41)语言,其主要功能有(42),它的典型句型为

 SELECT A1,A2,…,An

 FROM r1,r2,…,rm

 WHERE F

 其中A1,A2,…,An、r1,r2,…,rm和F分别是(43)。

 关系模式SCS(Sno,Cno,Score)中,Sno是学生的学号,Cno是课程号,Score为成绩。若要查询每门课程的平均成绩,且要求查询结果按平均成绩升序排列。平均成绩相同时,按课程号降序排列,可用SQL语言写为(44)。若查询结果仅限于平均分数超过85分的,则应(45)。

  • A.人工智能
  • B.关系数据库
  • C.函数型
  • D.高级算法
参考答案
查看试卷详情
相关试题
  1. (89)

    • A.system hardware
    • B.system software
    • C.keyboard
    • D.operation system
  2. (88)

    • A.deferring
    • B.suspending
    • C.hanging
    • D.holding
  3. (86)

    • A.updating
    • B.renovate
    • C.renew
    • D.rehabilitate
  4. (87)

    • A.route
    • B.passage
    • C.track
    • D.directory
  5. (84)

    • A.read
    • B.write
    • C.draw
    • D.fill
  6. User programs interact with the kernel through a set of standard(71). They request services to be provided by the kernel. Such services would include accessing a file: open close, read, write, link, or execute a file; starting or(72)accounting records; changing ownership of a file or(73); changing to a new directory; creating,(74), or killing a process; enabling access to hardware devices; and setting limits on system resources. Unix is a multi -user, multi -tasking operating system. You can have many users logged into a system simultaneously, each running many programs. It's the kernel's job to keep each process and user separate and to regulate access to(75), including cpu, memory, disk and other L/O devices.

    • A.system commands
    • B.system transfer
    • C.system calls
    • D.system rings
  7. (83)

    • A.read
    • B.write
    • C.speak
    • D.tell
  8. (82)

    • A.sets
    • B.dishes
    • C.disks
    • D.panels
  9. (81)

    • A.AI
    • B.Alt
    • C.Ant
    • D.Alnt
  10. (79)

    • A.图像的大小
    • B.图像的色彩
    • C.图像袁现的细节
    • D.图像序列变化的程度