070-516 無料問題集「Microsoft TS: Accessing Data with Microsoft .NET Framework 4」

（A）IEnumerable<Tuple<int, Part>> result = part.Descendants .Distinct() .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));

（B）IEnumerable<Tuple<int, Part>> result = part.Descendants .ToDictionary(c => c) .Select(d => Tuple.Create(d.Value.Children.Count(), d.Key));

（C）IEnumerable<Tuple<int, Part>> result = part.Children .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));

（D）IEnumerable<Tuple<int, Part>> result = part.Children .Distinct() .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));

（E）IEnumerable<Tuple<int, Part>> result = part.Descendants .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));

（A）Apply the ParameterAttribute to the stored procedure function. Use the GetResult<TElement> method to obtain an enumerator of the correct type.

（B）Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

（C）Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

（D）Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult<TElement> method to obtain an enumerator of the correct type.

（A）AddObject

（B）ApplyCurrentValues

（C）AttachTo

（D）Attach

（A）Encrypt stored passwords by using the RC2CryptoServiceProvider class.

（B）Append a random salt to the password by using the RNGCryptoServiceProvider class. Encrypt stored passwords by using the RijndaelManaged class.

（C）Append a random salt to the password by using the RNGCryptoServiceProvider class. Hash stored passwords by using the SHA1CryptoServiceProvider class.

（D）Encrypt stored passwords by using the TripleDESCryptoServiceProvider class.

（A）Override the Delete operation of the DataContext object.

（B）Modify the SELECT SQL statement provided to the DataContext object to use an INNER JOIN between the Customer and Orders tables.

（C）Override the Update operation of the DataContext object.

（D）Add new entities to the DataContext object for the Customers and Orders tables.

（A）from order in dataContext.Orders group order by order.OrderID into g join details in dataContext.Order_Detail on g.Key equals details.OrderID
select new
{
OrderID = details.OrderID,
CustomerID = details.Order.CustomerID,
TotalAmount = details.UnitPrice * details.Quantity
}

（B）dataContext.Orders.GroupJoin(dataContext.Order_Detail, o => o.OrderID, d => d.OrderID,
(ord, dts) => new {
OrderID = ord.OrderID,
CustomerID = ord.CustomerID,
TotalAmount = dts.Sum(od => od.UnitPrice *
od.Quantity)
})

（C）dataContext.Order_Detail.GroupJoin(dataContext.Orders, d => d.OrderID, o => o.OrderID,
(dts, ord) => new {
OrderID = dts.OrderID,
CustomerID = dts.Order.CustomerID,
TotalAmount = dts.UnitPrice * dts.Quantity
})

（D）from details in dataContext.Order_Detail group details by details.OrderID into g join order in dataContext.Orders on g.Key equals order.OrderID select new {
OrderID = order.OrderID,
CustomerID = order.CustomerID,
TotalAmount = g.Sum(od => od.UnitPrice * od.Quantity)
}

（A）XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Auto; XmlReader reader = XmlReader.Create("data.xml", settings);

（B）XmlReaderSettings settings = new XmlReaderSettings(); settings.ValidationType = ValidationType.None; XmlReader reader = XmlReader.Create("data.xml", settings);

（C）XmlReaderSettings settings = new XmlReaderSettings(); settings.CheckCharacters = true; XmlReader reader = XmlReader.Create("data.xml", settings);

（D）XmlReaderSettings settings = new XmlReaderSettings(); settings.XmlResolver = null; XmlReader reader = XmlReader.Create("data.xml", settings);

（A）Add the following code segment at line 06:
var strPrdUri = string.Format("Categories({0})?$expand=Products",
category.CategoryID);
var productUri = new Uri(strPrdUri, UriKind.Relative);
ctx.Execute<Product>(productUri);

（B）Add the following code segment at line 08:
ctx.LoadProperty(product, "*");

（C）Add the following code segment at line 06:
ctx.LoadProperty(category, "Products");

（D）Add the following code segment at line 08:
var strprdUri= string.format("Products?$filter=CategoryID eq {0}",
category.CategoryID);
var prodcutUri = new Uri(strPrd, UriKind.Relative);
ctx.Execute<Product>(productUri);

（A）catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
Trace.WriteLine("Message: " + ex.InnerException.Message);
}

（B）catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
Trace.WriteLine("Message: " + ex.Message);
}

（C）catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
Trace.WriteLine("Message: " + ex.InnerException.Message);
}

（D）catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
Trace.WriteLine("Message: " + ex.Message);
}

（A）categoryRow.Delete();

（B）ds.Tables[0].Rows.Remove(categoryRow);

（C）ds.Tables[0].Rows.RemoveAt(0);

（D）ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();