2013微软认证:sql认证考试练习试题9[1]

【网络综合 - 微软认证(MCSE)试题】
无忧考网为大家收集整理了《2013微软认证:sql认证考试练习试题9》供大家参考，希望对大家有所帮助！！！

第41题
你需要确定执行下面的代码片段的结果。 DECLARE @RangeStart INT = 0;DECLARE @RangeEnd INT = 10000;DECLARE @RangeStep INT = 1;
WITH NumberRange(ItemValue)AS (SELECT ItemValue FROM (SELECT @RangeStart AS ItemValue) AS tUNION ALL SELECT ItemValue + @RangeStepFROM NumberRangeWHERE ItemValue < @RangeEnd) SELECT ItemValue FROM NumberRangeOPTION (MAXRECURSION 100) 将返回哪个结果？
A. 将返回101行，且无错误。
B. 将返回10,001行，且无错误。
C. 将返回101行，有最大递归错误。
D. 将返回10,001行，有最大递归错误。
答案：C

第42题
你需要实现公用表表达式(CTE)。应使用哪个代码片段？
A. CREATE VIEW SalesByYear AS SELECT Year, Region, SUM(OrderTotal) FROM Orders GROUP BY Year, Region; GO SELECT Year, Region, Total FROM SalesByYear;
B. WITH SalesByYear(Year,Region,Total) AS (SELECT Year, Region, SUM(OrderTotal) FROM Orders GROUP BY Year,Region) SELECT Year, Region, Total FROM SalesByYear;
C. SELECT Year, Region, Total FROM ( SELECT Year, Region, SUM(OrderTotal) AS Total FROM Orders GROUP BY Year, Region) AS [SalesByYear];
D. SELECT DISTINCT Year, Region, ( SELECT SUM(OrderTotal) FROM Orders SalesByYear WHERE Orders.Year = SalesByYear.YEAR AND Orders.Region = SalesByYear.Region) AS [Total] FROM Orders;
答案：B

第43题
你有两个视图，分别名为Sales.SalesSummaryOverall和Sales.CustomerAndSalesSummary。 它们定义如下： CREATE VIEW Sales.SalesSummaryOverallAS SELECT CustomerId, SUM(SalesTotal) AS OverallTotalFROM Sales.SalesOrder GROUP BY CustomerId GO CREATE VIEW Sales.CustomerAndSalesSummaryAS SELECT Customer.Name, SalesSummaryOverall.OverallTotal, (SELECT AVG(OverallTotal)FROM Sales.SalesSummaryOverallWHERE SalesSummaryOverall.CustomerId = Customer.CustomerId) AS avgOverallTotal, (SELECT MAX(OverallTotal) FROM Sales.SalesSummaryOverallWHERE SalesSummaryOverall.CustomerId =Customer.CustomerId) AS maxOverallTotal,FROM Sales.Customer LEFT OUTER JOIN Sales. Sales.SalesSummaryOverallON SalesSummaryByYear.CustomerId = Customer.CustomerIdGO 你的任务是修改Sales.CustomerAndSalesSummary视图以删除对其微软认证(MCSE)