SQLServer2005期中考试试题及答案.docxVIP

SQLServer2005期中考试试题及答案

姓名：__________考号：__________

一、单选题(共10题)

1.在SQLServer中，如何创建一个名为Employee的表，包含ID、Name和Age三个字段？()

A.CREATETABLEEmployee(IDINT,NameVARCHAR(100),AgeINT)

B.CREATETABLEEmployee(IDINT,NameTEXT,AgeFLOAT)

C.CREATETABLEEmployee(IDINT,NameCHAR(100),AgeDECIMAL)

D.CREATETABLEEmployee(IDINT,NameVARCHAR(100),AgeVARCHAR(3))

2.以下哪个是SQLServer中的事务处理语句？()

A.SELECT

B.INSERT

C.UPDATE

D.COMMIT

3.如何删除Employee表中ID为5的记录？()

A.DELETEFROMEmployeeWHEREID=5

B.DELETEEmployeeWHEREID=5

C.DELETEFROMEmployeeWHEREID=5

D.DELETEFROMEmployeeWHEREID=5.0

4.在SQLServer中，如何创建一个名为Orders的视图，显示所有订单的ID和总价？()

A.CREATEVIEWOrdersASSELECTOrderID,TotalPriceFROMOrders

B.CREATEVIEWOrdersASSELECTOrderID,SUM(TotalPrice)FROMOrders

C.CREATEVIEWOrdersASSELECTOrderID,COUNT(TotalPrice)FROMOrders

D.CREATEVIEWOrdersASSELECTOrderID,AVG(TotalPrice)FROMOrders

5.以下哪个是SQLServer中的索引类型？()

A.ClusteredIndex

B.Non-ClusteredIndex

C.Full-TextIndex

D.Alloftheabove

6.如何查询Employee表中年龄大于30的员工姓名？()

A.SELECTNameFROMEmployeeWHEREAge30

B.SELECTNameFROMEmployeeWHEREAge=30

C.SELECTNameFROMEmployeeWHEREAge=30

D.SELECTNameFROMEmployeeWHEREAge30

7.在SQLServer中，如何将Employee表中的所有年龄字段值增加1？()

A.UPDATEEmployeeSETAge=Age+1

B.UPDATEEmployeeSETAge+=1

C.UPDATEEmployeeSETAge=Age+1.0

D.UPDATEEmployeeSETAge=Age+1.1

8.以下哪个是SQLServer中的存储过程？()

A.CREATETABLE

B.INSERTINTO

C.CREATEPROCEDURE

D.SELECT*FROM

9.如何查询Employee表中所有员工的姓名和邮箱地址？()

A.SELECTName,EmailFROMEmployee

B.SELECTName,EmailFROMEmployeeWHERENameISNOTNULL

C.SELECTName,EmailFROMEmployeeWHEREEmailISNOTNULL

D.SELECTName,EmailFROMEmployeeWHERENameOREmailISNOTNULL

10.在SQLServer中，如何将Employee表中的所有记录复制到NewEmployee表中？()

A.INSERTINTONewEmployeeSELECT*FROMEmployee

B.SELECT*INTONewEmployeeFROMEmployee

C.CREATETABLENewEmploye