sql练习题 答案_原创精品文档.docxVIP

sql练习题答案

姓名：__________考号：__________

一、单选题(共10题)

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

A.CREATETABLEstudents(idINT,nameVARCHAR(100))

B.CREATETABLEstudents(nameVARCHAR(100),idINT)

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

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

2.在SQL中，如何查询名为Alice的学生信息？()

A.SELECT*FROMstudentsWHEREname=Alice

B.SELECT*FROMstudentsWHEREnames=Alice

C.SELECT*FROMstudentsWHEREName=Alice

D.SELECT*FROMstudentsWHEREname=alice

3.以下哪个SQL命令可以删除名为students的表？()

A.DELETEFROMstudents

B.DROPTABLEstudents

C.TRUNCATETABLEstudents

D.DELETETABLEstudents

4.如何将students表中所有学生的年龄加1？()

A.UPDATEstudentsSETage=age+1

B.UPDATEstudentsSETage=age+1WHEREage=1

C.UPDATEstudentsSETage=age-1

D.UPDATEstudentsSETage=1

5.在SQL中，如何连接两个表以获取相关数据？()

A.JOIN

B.UNION

C.INNERJOIN

D.OUTERJOIN

6.如何查询students表中年龄大于20的学生信息？()

A.SELECT*FROMstudentsWHEREage20

B.SELECT*FROMstudentsWHEREage=20

C.SELECT*FROMstudentsWHEREage20

D.SELECT*FROMstudentsWHEREage=20

7.以下哪个SQL命令可以插入一条新记录到students表中？()

A.INSERTINTOstudents(id,name,age)VALUES(1,John,25)

B.INSERTINTOstudents(name,age,id)VALUES(John,25,1)

C.INSERTINTOstudentsVALUES(1,John,25)

D.INSERTINTOstudentsVALUES(John,25,1)

8.在SQL中，如何使用LIKE操作符进行模糊匹配查询？()

A.SELECT*FROMstudentsWHEREnameLIKE%John%

B.SELECT*FROMstudentsWHEREnameLIKEJohn%

C.SELECT*FROMstudentsWHEREnameLIKE%John

D.SELECT*FROMstudentsWHEREnameLIKEJohn

9.以下哪个SQL命令可以统计students表中学生的数量？()

A.SELECTCOUNT(*)FROMstudents

B.SELECTCOUNT(*)FROMstudentsWHEREid0

C.SELECTCOUNT(id)FROMstudents

D.SELECTCOUNT(*)FROMstudentsWHEREage0

10.如何将students表中所有学生的年龄字段重命名为age_old？()

A.ALTERTABLEstudentsRENAMECOLUMNageTOage_old

B.ALTERTABLEstudentsageage_old

C.ALTERTABLEstudentsage_oldage

D.ALTERTABLEst