数据库操作试题及答案.docx

数据库操作试题及答案

姓名：__________考号：__________

一、单选题(共10题)

1.在SQL中，如何创建一个名为students的表，包含id（主键）、name和age三个字段？()

A.CREATETABLEstudents(idINTPRIMARYKEY,nameVARCHAR(100),ageINT);

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

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

D.CREATETABLEstudents(idINTPRIMARYKEY,nameVARCHAR(100),ageINT,PRIMARYKEY(id));

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

A.SELECT*FROMstudentsWHEREage20;

B.SELECT*FROMstudentsWHEREage20;

C.SELECT*FROMstudentsWHEREage=20;

D.SELECT*FROMstudentsWHEREage=20;

3.在SQL中，如何将students表中所有学生的年龄增加1岁？()

A.UPDATEstudentsSETage=age+1WHEREage0;

B.UPDATEstudentsSETage=age+1;

C.UPDATEstudentsSETage=age-1WHEREage0;

D.UPDATEstudentsSETage=age-1;

4.在SQL中，如何删除students表中所有年龄小于18岁的记录？()

A.DELETEFROMstudentsWHEREage18;

B.DELETEFROMstudentsWHEREage=18;

C.DELETEFROMstudentsWHEREage18;

D.DELETEFROMstudentsWHEREage=18;

5.在SQL中，如何插入一条新的学生记录到students表中？()

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

B.INSERTINTOstudents(name,age,id)VALUES(Alice,20,1);

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

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

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

A.SELECTname,ageFROMstudentsWHEREage0;

B.SELECTname,ageFROMstudentsWHEREage0;

C.SELECTname,ageFROMstudentsWHEREage=0;

D.SELECTname,ageFROMstudentsWHEREage=0;

7.在SQL中，如何修改students表中某个学生的姓名？()

A.UPDATEstudentsSETname=BobWHEREid=1;

B.UPDATEstudentsSETname=BobWHEREage=20;

C.UPDATEstudentsSETname=BobWHEREid=1;

D.UPDATEstudentsSETname=BobWHEREid=1.0;

8.以下哪个SQL语句可以查询年龄在18到25岁之间的所有学生？()

A.SELECT*FROMstudentsWHEREageBETWEEN18AND25;

B.SELECT*FROMstudentsWHEREageNOTBETWEEN18AND25;

C.SELECT*FROMstudentsWHEREage18ANDage25;

D.SEL