access操作题(提示)_原创精品文档.docxVIP

access操作题(提示)

姓名：__________考号：__________

一、单选题(共10题)

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

A.CREATETABLEstudents(idINT,nameVARCHAR(50))

B.CREATETABLEstudents(nameVARCHAR(50),idINT)

C.CREATETABLEstudentsidINT,nameVARCHAR(50)

D.CREATETABLEstudents(nameINT,nameVARCHAR(50))

2.以下哪个SQL语句可以查询students表中所有学生的名字？()

A.SELECTnameFROMstudents

B.SELECT*FROMstudents

C.SELECTnameFROMstudentsWHEREid0

D.SELECTstudents.nameFROMstudents

3.以下哪个SQL语句可以更新students表中id为1的学生的名字为Alice？()

A.UPDATEstudentsSETname=AliceWHEREid=1

B.UPDATEstudentsWHEREname=AliceSETid=1

C.UPDATEstudentsname=AliceSETid=1

D.UPDATEstudentsSETname=AliceWHEREname=Alice

4.以下哪个SQL语句可以删除students表中id为2的记录？()

A.DELETEFROMstudentsWHEREid=2

B.DELETEstudentsWHEREid=2

C.DELETEFROMstudentsWHEREid=2SETid=2

D.DELETEFROMstudentsWHEREid=2,name=Alice

5.以下哪个SQL语句可以插入一条新的记录到students表中，其中id为3，名字为Bob？()

A.INSERTINTOstudents(id,name)VALUES(3,Bob)

B.INSERTINTOstudentsVALUES(3,Bob)

C.INSERTINTOstudents(id,name)VALUES(Bob,3)

D.INSERTINTOstudentsVALUES(Bob,3)

6.以下哪个SQL语句可以计算students表中所有学生的名字长度总和？()

A.SELECTSUM(LENGTH(name))FROMstudents

B.SELECTSUM(name)FROMstudents

C.SELECTLENGTH(name)FROMstudents

D.SELECTSUM(name)AStotal_lengthFROMstudents

7.以下哪个SQL语句可以查询students表中年龄大于20的学生名字？()

A.SELECTnameFROMstudentsWHEREage20

B.SELECTnameFROMstudentsWHEREnameLIKE%20%

C.SELECTnameFROMstudentsWHEREname20

D.SELECTnameFROMstudentsWHEREnameLIKE%20

8.以下哪个SQL语句可以查询students表中名字以A开头的所有学生记录？()

A.SELECT*FROMstudentsWHEREnameLIKEA%

B.SELECT*FROMstudentsWHEREnameLIKE%A

C.SELECT*FROMstudentsWHEREnameLIKEA%

D.SELECT*FROMstudentsWHEREnameLIKE%A%

9.以下哪个SQL语句可以查询students表中名字长度为5的所有学生记录？()

A.SELECT*FROMstudentsWHERELENGTH(name)=5

B.SELECT*FROMstudentsWHEREname=ABCDE

C.SELECT*FROMstudentsWHEREnameLIKE*****