SQL 习题_原创精品文档.docxVIP

SQL习题

姓名：__________考号：__________

一、单选题(共10题)

1.以下哪个SQL语句可以查询名为‘students’的表中所有学生的姓名和年龄？()

A.SELECTname,ageFROMstudents

B.SELECTname,ageFROMstudentsWHEREname=students

C.SELECTname,ageFROMstudentsWHEREage=students

D.SELECTnameFROMstudentsWHEREname=studentsANDage=students

2.以下哪个SQL语句可以删除名为‘students’的表中所有记录？()

A.DELETEFROMstudentsWHEREid0

B.DELETEFROMstudentsWHEREid=0

C.DELETEFROMstudents

D.DELETEstudents

3.以下哪个SQL语句可以创建一个名为‘students’的新表，包含‘id’和‘name’两个字段？()

A.CREATETABLEstudents(idINT,nameVARCHAR(100))

B.CREATETABLEstudentsidINT,nameVARCHAR(100)

C.CREATETABLEstudents(idINT,nameVARCHAR(100),)

D.CREATETABLEstudentsidINT,nameVARCHAR(100)

4.以下哪个SQL语句可以更新名为‘students’的表中‘name’字段的值？()

A.UPDATEstudentsSETname=JohnWHEREid=1

B.UPDATEstudentsSETname=Johnid=1

C.UPDATEstudentsSETname=JohnWHEREid=1;

D.UPDATEstudentsSETname=JohnWHEREid=1,name=John

5.以下哪个SQL语句可以查询名为‘students’的表中年龄大于20岁的学生姓名？()

A.SELECTnameFROMstudentsWHEREage20

B.SELECTnameFROMstudentsWHEREage=20

C.SELECTnameFROMstudentsWHEREage20

D.SELECTnameFROMstudentsWHEREage=20

6.以下哪个SQL语句可以查询名为‘students’的表中年龄在18到25岁之间的学生姓名？()

A.SELECTnameFROMstudentsWHEREageBETWEEN18AND25

B.SELECTnameFROMstudentsWHEREage=18AND=25

C.SELECTnameFROMstudentsWHEREageBETWEEN18AND25;

D.SELECTnameFROMstudentsWHEREageBETWEEN18AND25,ageBETWEEN18AND25

7.以下哪个SQL语句可以查询名为‘students’的表中年龄不在18到25岁之间的学生姓名？()

A.SELECTnameFROMstudentsWHEREageNOTBETWEEN18AND25

B.SELECTnameFROMstudentsWHEREageNOT=18ANDNOT=25

C.SELECTnameFROMstudentsWHEREageNOTBETWEEN18AND25;

D.SELECTnameFROMstudentsWHEREageNOTBETWEEN18AND25,ageNOTBETWEEN18AND25

8.以下哪个SQL语句可以查询名为‘students’的表中年龄为偶数的所有学生姓名？()

A.SELECTnameFROMstudentsWHEREage%2=0

B.SELECTnameFROMstudentsWHEREage%2=1

C.SELECTnameFROMstu