微软认证sql考试练习试题及答案.doc

文档介绍：微软认证sql考试练****试题及答案

　　第1题

　　公司在数据库中存储供应商和价格信息。数据库中的所有商品都有牌价list price。 。应使用哪个查询?

　　A. UPDATE SET ListPrice = ListPrice + WHERE NOT EXISTS SELECT VendorId FROM WHERE VendorName = ’Fabrikam’;

　　B. UPDATE SET ListPrice = ListPrice + WHERE VendorId NOT IN SELECT VendorId FROM WHERE VendorName = ’Fabrikam’;

　　C. UPDATE SET ListPrice = ListPrice + WHERE EXISTS SELECT VendorId FROM WHERE VendorName = ’Fabrikam’;

　　D. UPDATE SET ListPrice = ListPrice + WHERE VendorId IN SELECT VendorId FROM WHERE VendorName = ’Fabrikam’;

　　答案：D

　　第2题

　　你有名为Customer和SalesOrder的两个表。 你需要找出尚未采购任何东西的所有客户， 以及那些订单总额 OrderTotal 不到100的客户。应使用哪个查询?

　　A. SELECT * FROM Customer WHERE 100 > ALL SELECT OrderTotal FROM SalesOrder WHERE =

　　B. SELECT * FROM Customer WHERE 100 > SOME SELECT OrderTotal FROM SalesOrder WHERE =

　　C. SELECT * FROM Customer WHERE 100 > SELECT MAXOrderTotal FROM SalesOrder WHERE =

　　D. SELECT * FROM Customer WHERE EXISTS SELECT FROM SalesOrder WHERE = SalesOrder