2026年sql笔试题多表含答案解析.docxVIP

2026年sql笔试题多表含答案解析

姓名：__________考号：__________

题号

一

二

三

四

五

总分

评分

一、单选题(共10题)

1.假设有两个表：Employee（员工表）和Department（部门表），Employee表包含字段：EmpID（员工ID）、Name（姓名）、DepartmentID（部门ID），Department表包含字段：DepartmentID（部门ID）、DepartmentName（部门名称）。以下哪个SQL语句可以查询所有部门名称和对应的员工数量？()

A.SELECTDepartmentName,COUNT(*)ASEmployeeCountFROMDepartment,EmployeeGROUPBYDepartmentName

B.SELECTDepartmentName,COUNT(*)ASEmployeeCountFROMDepartmentJOINEmployeeONDepartment.DepartmentID=Employee.DepartmentIDGROUPBYDepartmentName

C.SELECTDepartmentName,COUNT(*)ASEmployeeCountFROMDepartmentINNERJOINEmployeeONDepartment.DepartmentID=Employee.DepartmentIDGROUPBYDepartmentName

D.SELECTDepartmentName,COUNT(*)ASEmployeeCountFROMDepartmentLEFTJOINEmployeeONDepartment.DepartmentID=Employee.DepartmentIDGROUPBYDepartmentName

2.以下哪个SQL语句可以更新Employee表中名为“John”的员工的部门ID为10？()

A.UPDATEEmployeeSETDepartmentID=10WHEREName=John

B.UPDATEEmployeeSETName=JohnWHEREDepartmentID=10

C.UPDATEDepartmentSETName=JohnWHEREDepartmentID=10

D.UPDATEEmployeeSETDepartmentID=10WHEREName=JohnANDDepartmentID=10

3.以下哪个SQL语句可以删除Department表中部门名称为“IT”的记录？()

A.DELETEFROMDepartmentWHEREDepartmentName=IT

B.DELETEDepartmentWHEREDepartmentName=IT

C.DELETEFROMDepartmentSETDepartmentName=IT

D.DELETEFROMDepartmentWHEREDepartmentName=ITANDDepartmentID=10

4.以下哪个SQL语句可以创建一个名为“Products”的新表，包含字段：ProductID（产品ID）、ProductName（产品名称）和Price（价格）？()

A.CREATETABLEProducts(ProductIDINT,ProductNameVARCHAR(255),PriceDECIMAL(10,2))

B.CREATETABLEProductsProductIDINT,ProductNameVARCHAR(255),PriceDECIMAL(10,2)

C.CREATETABLEProductsProductIDINT,ProductNameVARCHAR(255),PriceDECIMAL(10,2)PRIMARYKEY

D.CREATETABLEProductsProductIDINT,ProductNameVARCHAR(255),PriceDECIMAL(10,2)NOTNULL

5.以下哪个SQL语句可以查询Employee表中所有员工的姓名和他们的直接上级的姓名？()

A.SELECTE.Name,M.NameASManagerNameFROMEmployee