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

SQL练习题

姓名：__________考号：__________

一、单选题(共10题)

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

A.CREATETABLEstudents(idINT,nameVARCHAR(100))

B.CREATETABLEstudentsidINT,nameVARCHAR(100)

C.CREATETABLEstudents(id,nameINT,VARCHAR(100))

D.CREATETABLEstudents(idINT,nameVARCHAR(100);

2.在SQL中，如何查询名为John的学生的年龄？()

A.SELECTageFROMstudentsWHEREname=John

B.SELECTageFROMstudentsWHEREnameISJohn

C.SELECTageFROMstudentsWHEREname==John

D.SELECTageFROMstudentsWHEREnameLIKEJohn

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

A.DELETETABLEstudents

B.DROPTABLEstudents

C.TRUNCATETABLEstudents

D.DELETEFROMstudents

4.在SQL中，如何更新名为John的学生的年龄为25岁？()

A.UPDATEstudentsSETage=25WHEREname=John

B.UPDATEstudentsSETage=25WHEREname=John

C.UPDATEstudentsSETname=JohnWHEREage=25

D.UPDATEstudentsSETage=25WHEREname=John;

5.以下哪个SQL语句可以插入一条记录到名为students的表中？()

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

B.INSERTINTOstudentsid,name,ageVALUES(1,John,20)

C.INSERTINTOstudents(id,name,age)VALUES(1,John,20)

D.INSERTINTOstudents(id,name,age)VALUES(1,John,20);

6.在SQL中，如何计算所有学生的平均年龄？()

A.SELECTAVG(age)FROMstudents

B.SELECTAVG(name)FROMstudents

C.SELECTSUM(age)FROMstudents

D.SELECTCOUNT(name)FROMstudents

7.以下哪个SQL语句可以查询年龄大于20岁的学生？()

A.SELECT*FROMstudentsWHEREage20

B.SELECT*FROMstudentsWHEREage=20

C.SELECT*FROMstudentsWHEREage20

D.SELECT*FROMstudentsWHEREage=20

8.在SQL中，如何对students表中的年龄字段进行降序排序？()

A.SELECT*FROMstudentsORDERBYageDESC

B.SELECT*FROMstudentsORDERBYageASC

C.SELECT*FROMstudentsORDERBYage

D.SELECT*FROMstudentsORDERBYageDESC;

9.以下哪个SQL语句可以查询所有学生的姓名和年龄？()

A.SELECTname,ageFROMstudents

B.SELECTname,ageFROMstudentsWHEREnameISNOTNULL

C.SELECTname,ageFROMstudentsWHEREageISNOTNULL

D.SELECTname,ageFROMstudentsWHEREnameANDageISNOTN