SQL base 综合测试题(SCME)_原创精品文档.docxVIP

SQLbase综合测试题(SCME)

姓名：__________考号：__________

一、单选题(共10题)

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

A.CREATETABLEemployees(idINTPRIMARYKEY,nameVARCHAR(50),ageINT)

B.CREATETABLEemployees(idINT,nameVARCHAR(50),ageINTPRIMARYKEY)

C.CREATETABLEemployees(idINT,nameVARCHAR(50),ageINT)

D.CREATETABLEemployees(idVARCHAR(50),nameINT,ageINTPRIMARYKEY)

2.以下哪个SQL语句是用来插入数据到`employees`表中的？()

A.INSERTINTOemployees(id,name,age)VALUES(1,Alice,30)

B.INSERTemployees(id,name,age)VALUES(1,Alice,30)

C.INSERTINTOemployees(id,name,age)VALUES(1,Alice,30)

D.INSERTINTOemployees(id,name,age)VALUES(1,Alice,30,25)

3.如何删除`employees`表中所有记录，但保留表结构？()

A.DELETEFROMemployees

B.TRUNCATETABLEemployees

C.DROPTABLEemployees

D.ALTERTABLEemployeesDROPALL

4.以下哪个函数是用来获取当前日期和时间的？()

A.CURRENT_DATE

B.CURRENT_TIME

C.NOW()

D.GETDATE()

5.在SQL中，如何查询`employees`表中年龄大于30的员工姓名？()

A.SELECTnameFROMemployeesWHEREage30

B.SELECTnameFROMemployeesWHEREage=30

C.SELECTnameFROMemployeesWHEREage=30

D.SELECTnameFROMemployeesWHEREage30

6.如何更新`employees`表中所有员工的`age`字段值为`age+1`？()

A.UPDATEemployeesSETage=age+1

B.UPDATEemployeesSETage+1=age

C.UPDATEemployeesSETage=age

D.UPDATEemployeesSETage=age-1

7.如何连接`employees`表和`departments`表，以获取所有部门的员工姓名和部门名称？()

A.SELECTe.name,d.nameFROMemployeeseINNERJOINdepartmentsdONe.department_id=d.id

B.SELECTe.name,d.nameFROMemployeeseLEFTJOINdepartmentsdONe.department_id=d.id

C.SELECTe.name,d.nameFROMemployeeseRIGHTJOINdepartmentsdONe.department_id=d.id

D.SELECTe.name,d.nameFROMemployeeseFULLOUTERJOINdepartmentsdONe.department_id=d.id

8.以下哪个SQL语句是用来创建索引的？()

A.CREATEINDEXindex_nameONtable_name(column_name)

B.CREATEINDEXtable_nameONindex_name(column_name)

C.CREATEindex_nameONtable_name(column_name)

D.CREATEINDEX(c