单选

●已知基本表:学生(学号,姓名,性别,年龄,系名)

选课(学号,课程号,成绩)

要检索所有比"王华"年龄大的学生姓名、年龄和性别,正确的语句是 (25) ,要检索学生姓名及其所选修课程的课程号和成绩,正确的语句是 (26) 。

(25)

  • A.SELECT姓名,年龄,性别
  • FROM学生    WHERE AGE>(SELECT 年龄
  • FROM 学生    WHERE 姓名 ="王华")    &n
  • bsp;  B.SELE
  • CT姓名,年龄,性别
  • FROM学生    WHERE姓名="王华"
  • C.SELECT姓名,年龄,性别
  • FROM学生    WHERE AGE>(SELECT年龄    WHERE姓名="王华")    
  • D.SELECT姓名,年龄,性别
  • FROM学生    WHERE AGE>"王华"    (26) A.SELECT 学生.姓名,选课.课程号,选课.成绩
  • FROM学生    WHERE学生 学号=课程.学号
  • B.SELECT学生.姓名,选课.课程号,选课.成绩
  • FROM选课    WHERE学生.学号=课程.学号
  • C.SELECT学生.姓名,选课.课程号,选课.成绩
  • FROM学生,选课    WHERE学生.学号=课程.学号
  • D.SELECT学生.姓名,选课.课程号,选课.成绩
  • FROM学生.学号
参考答案
您可能感兴趣的试题

  • ASCII is a 7-
  • bit
  • co
  • de used to represent numeric,alphabetic,and special printable characters.It also includes codes for control characters,which are (75) .    (75) A.printable or displayable
  • B.not printable or displayable
  • C.not printable but displayable
  • D.printable but not displayable

●The error mess

  • ages given
  • by a
  • C compiler show the message text,the most common cause of the error,an
  • d a suggestion for  (73) the error.    (73) A.upfsying
  • B.fixing
  • C.changing
  • D.Editing

●How m

  • any key comparisons are needed in searching for key value 38?&n
  • bsp;(74) .    (74) A.1
  • B.4    
  • C.3    
  • D.2

●By me

  • ans of multiple pipeline to carry out multiple processing,this technology is called&n
  • bsp;(71) .    (71) A.Multiple pipeling
  • B.Superpipeline    
  • C.Superscalar    
  • D.Very long instruction word

●Tr

  • ansport gateways connect
  • byte streams in the transport layer.Appli
  • cation gateways allow interworking above (72) .    (72) A.network layer
  • B.
  • data link layer
  • C.transport layer
  • D.appfication layer

  • An instruction that uses indrect addressing mustt contain an address of memory where&n
  • bsp;(69) .    (69) A.data is stored
  • B.a pipeline stall will be exe
  • cute
  • d
  • C.a page fault is addressed
  • D.another address is stored

●Wh

  • at is the decimal value of the
  • binary value 10010? (70) .    (70) A.18
  • B.20    
  • C.14    
  • D.15

●In which ph

  • ase of the software engineering process is the Software Requirements Specification developed?&n
  • bsp; (68) .    (68) A.development phase
  • B.engineering phase    
  • C.maintenance phase    
  • D.Definition phase

● The sorting method described by the code is c

  • alled&n
  • bsp;(67) .    (67) A.Insertion sort
  • B.Sele
  • ction sort
  • C.Ra
  • dix sort
  • D.Merge sort
¥

订单号:

遇到问题请联系在线客服

订单号:

遇到问题请联系在线客服