单选

已知有关系模式及(S_N0,S_NAME,AGE),其中S_NO表示学生的学号,类型为Char[8],前4位表示入学年份。查询所有2005年入学的学生姓名(S_NAME),SQL语句是()。

  • A.SELECT S_NAME FROM R WHERE S_NO = '2005% '
  • B.SELECT S_NAME FROM R WHERE S_NO LIKE '2005% '
  • C.SELECT S_NAME FROM R WHERE S_NO = '2005%'
  • D.SELECT S_NAME FROM R WHERE S_NO LIKE '2005%'
参考答案
您可能感兴趣的试题

(66)

  • A.service
  • B.servant
  • C.servants
  • D.services

(65)

  • A.logging
  • B.going
  • C.coming
  • D.achieving

(64)

  • A.visiting
  • B.assessing
  • C.accessing
  • D.calling

(63)

  • A.database
  • B.gateway
  • C.router
  • D.computers

Which of the following statements about object oriented database is not correct?(72).

  • A.Each object has a unique object identify in the system
  • B.Encapsulation and inheritance are two important features of object oriented database
  • C.A subclass can inherit the attributes and methods of all its superclasses
  • D.A supereloss includes the attributes and methods at all subclasses
¥

订单号:

遇到问题请联系在线客服

订单号:

遇到问题请联系在线客服