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

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

第26题
你有两个表，分别名为SalesPerson和SalesTerritory。你需要使用笛卡尔积来创建示例数据，该积包含SalesPerson和 SalesTerritory表中的数据。应使用哪个代码片段？
A. SELECT p.SalesPersonId, t.Name AS [Territory] FROM Sales.SalesPerson p FULL JOIN Sales.SalesTerritory t ON p.TerritoryId = t.TerritoryId
B. SELECT p.SalesPersonId, Name AS [Territory] FROM Sales.SalesPerson p INNER JOIN Sales.SalesTerritory t ON p.TerritoryId = t.TerritoryId
C. SELECT p.SalesPersonId, t.Name AS [Territory] FROM Sales.SalesPerson p CROSS JOIN Sales.SalesTerritory t WHERE p.TerritoryId = t.TerritoryId
D. SELECT p.SalesPersonId, t.Name AS [Territory] FROM Sales.SalesPerson p CROSS JOIN Sales.SalesTerritory t;
答案：D

第27题
你有名为Subcategories的表，其中包含子类别socks、vests和helmets。你另有一个名为Products的表，其中只包含socks 和vests子类别的产品。你有下面的查询： SELECT s.Name, p.Name AS ProductNameFROM Subcategories s OUTER APPLY (SELECT * FROM Products pr WHERE pr.SubcategoryID = s.SubcategoryID) pWHERE s.Name IS NOT NULL; 你需要预测查询结果。该查询应生成什么结果？
A. Name ProductName Socks Mountain Bike Socks, Socks Mountain Bike Socks, Socks Racing Socks, M Socks Racing Socks, L Vests Classic Vest, S Vests Classic Vest, M Vests Classic Vest, L
B. Name ProductName Socks Mountain Bike Socks, Socks Mountain Bike Socks, Socks Racing Socks, M Socks Racing Socks, L Vests Classic Vest, S Vests Classic Vest, M Vests Classic Vest, L Helmets NULL
C. Name ProductName Socks Mountain Bike Socks, Socks Mountain Bike Socks, Socks Racing Socks, M Socks Racing Socks, L Vests Classic Vest, S Vests Classic Vest, M Vests Classic Vest, L Helmets NULL NULL NULL
D. Name ProductName Socks Mountain Bike Socks, Socks Mountain Bike Socks, Socks Racing Socks, M Socks Racing Socks, L Vests Classic Vest, S Vests Classic Vest, M Vests Classic Vest, L NULL Mountain Bike Socks, NULL Mountain Bike Socks, NULL Racing Socks, M NULL Racing Socks, L NULL Classic Vest, S NULL Classic Vest, M NULL Classic Vest微软认证(MCSE)