A.Update grade set score=score+5
B.Update grade set score=score+5 where score>=55 or score <=60
C.Update grade set score=score+5 where score between 55 and 60
D.Update grade set score=score+5 where score >=55 and score <=60

A.select top 1 * from book order by price asc
B.select top 1 * from book order by price desc
C.select top 1 * from book where price= (select max (price)from book)
D.select top 1 * from book where price= max(price)

A.select max(score) from grade 
B.select top 1 score from grade order by score asc 
C.Select min(score) from grade 
D.select top 1 score from grade order by score desc

A.01053090A#Hm3？
B.01003090A01
C.01053090D09
D.0101A01

A.Truncate table 可跟Where从句，根据条件进行删除 
B.Truncate table 用来删除表中所有数据 
C.触发器对Truncate table无效 
D.delete 比Truncate table速度快

A.SELECT * FROM 学习经历 WHERE 毕业学校 LIKE ’*清华*’ 
B.SELECT * FROM 学习经历 WHERE 毕业学校 = ’清华%’ 
C.SELECT * FROM 学习经历 WHERE 毕业学校 LIKE ’?清华?’ 
D.SELECT * FROM 学习经历 WHERE 毕业学校 LIKE ’%清华%’

A.AND
B.NOT
C.OR
D.XOR

A.Select * from [order details] Order by quantity desc 
B.Select * from [order details] Order by quantity asc
C.Select * from [order details] Order by quantity
D.Select * from [order details] Order by desc quantity

A.SELECT * FROM Products WHERE UnitPrice >= 20 OR UnitPrice <= 40 
B.SELECT * FROM Products WHERE UnitPrice BETWEEN 20 OR 40
C.SELECT * FROM Products WHERE UnitPrice >= 20 AND UnitPrice <= 40
D.SELECT * FROM Products WHERE UnitPrice BETWEEN 20 AND 40

A.SELECT Product Name AS’产品的名称’，Unit Price  AS’单价’FROM Products
B.SELECT Product Name=产品的名称，Unit Price=单价FROM Products
C.SELECT Product Name=“产品的名称”，Uni tPrice=“单价”FROM Products
D.SELECT Product Name’产品的名称’，Unit Price’单价’FROM Products