数据库练习题及答案解析题库大全.docxVIP

数据库练习题及答案解析

姓名：__________考号：__________

一、单选题(共10题)

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

A.CREATETABLEstudents(idINT,nameVARCHAR(100));

B.CREATETABLEstudents(nameVARCHAR(100),idINT);

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

D.CREATETABLEstudents(idVARCHAR(100),nameINT);

2.如何删除名为students的表？()

A.DELETEFROMstudents;

B.DROPTABLEstudents;

C.ALTERTABLEstudentsDROPCOLUMNid;

D.TRUNCATETABLEstudents;

3.以下哪个函数可以返回表中的记录数？()

A.COUNT(*)

B.SUM(*)

C.AVG(*)

D.MAX(*)

4.以下哪个SQL语句可以实现将students表中name字段的值更新为空？()

A.UPDATEstudentsSETname=;

B.UPDATEstudentsSETname=NULL;

C.UPDATEstudentsSETname=DEFAULT(name);

D.UPDATEstudentsSETname=COALESCE(name,);

5.以下哪个SQL语句可以查询students表中所有id大于10的记录？()

A.SELECT*FROMstudentsWHEREid10;

B.SELECT*FROMstudentsWHEREid=10;

C.SELECT*FROMstudentsWHEREid=10;

D.SELECT*FROMstudentsWHEREid10;

6.如何使用SQL语句查询students表中name字段包含张三的记录？()

A.SELECT*FROMstudentsWHEREnameLIKE张三%;

B.SELECT*FROMstudentsWHEREnameLIKE%张三%;

C.SELECT*FROMstudentsWHEREnameLIKE%张三;

D.SELECT*FROMstudentsWHEREnameLIKE张三;

7.以下哪个SQL语句可以创建一个名为teachers的视图，显示所有students表中的记录？()

A.CREATEVIEWteachersASSELECT*FROMstudents;

B.CREATEVIEWteachersASFROMstudents;

C.CREATEVIEWteachersASSELECTstudents.*FROMstudents;

D.CREATEVIEWteachersASSELECTFROMstudents;

8.如何使用SQL语句将students表中id为5的记录的name字段更新为李四？()

A.UPDATEstudentsSETname=李四WHEREid=5;

B.UPDATEstudentsSETname=李四WHEREid=5.0;

C.UPDATEstudentsSETname=李四WHEREid=5;

D.UPDATEstudentsSETname=李四WHEREid=5.5;

9.以下哪个SQL语句可以删除students表中所有id小于10的记录？()

A.DELETEFROMstudentsWHEREid10;

B.DELETEFROMstudentsWHEREid=10;

C.DELETEFROMstudentsWHEREid=10;

D.DELETEFROMstudentsWHEREid10;

10.以下哪个SQL语句可以查询students表中年龄在20到30岁之间的记录？()

A.SELECT*FROMstudentsWHEREageBETWEEN20AND30;

B.SELECT*FROMstude