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

（A）Add a function import for the Product entity type.

（B）Add a new entity that has a base class of Product that is mapped to the stored procedure.

（C）Add a stored procedure mapping for the Product entity type.

（D）Add a complex type named Product that is mapped to the stored procedure.

（A）return doc.Elements("bib").Elements() .Where(e1 => e1.Elements().Any(e2 => (string)e2 == "Author1"));

（B）return doc.Elements("bib").Elements()
.Where(e1 => e1.Elements().Any(e2 => e2.Equals(new XElement("author", "Author1"))));

（C）return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => (string)e2 == "Author1"));

（D）return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => e2.Equals(new XElement("author", "Author1"))));

（A）sqlTran.Commit(); } catch (Exception ex) {
Trace.WriteLine(ex.Message);
try {
sqlTran.Rollback();
}
catch (Exception exRollback) {
Trace.WriteLine(exRollback.Message);
}
}

（B）sqlTran.Commit(); } catch (Exception ex) {
sqlTran.Rollback();
Trace.WriteLine(ex.Message);
}

（C）catch (Exception ex) { sqlTran.Rollback();
Trace.WriteLine(ex.Message);
}
finaly {
try {
sqltran.commit( );
}
catch (Exception exRollback) {
Trace.WriteLine(excommit.Message);
}
}

（D）catch (Exception ex){ Trace.WriteLine(ex.Message); try{
sqlTran.Rollback();
}
catch (Exception exRollback){
Trace.WriteLine(exRollback.Message);
}
}
finaly {
sqltran.commit( );
}

（A）DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); dt.ExtendedProperties["RowCount"] = 10; dt.ExtendedProperties["RowIndex"] = 0; adapter.Fill(dt);

（B）DataSet ds = new DataSet(); ds.ExtendedProperties["RowCount"] = 10; ds.ExtendedProperties["RowIndex"] = 0; adapter.Fill(ds);

（C）DataSet ds = new DataSet(); adapter.Fill(ds, 0, 10, "Product");

（D）DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); adapter.Fill(0, 10, dt);

（A）Use encryption to store sensitive data in the database.

（B）Use Internet Protocol Security (IPSec) to secure the communication channel.

（C）Encrypt the connection string.

（D）Use Secure Sockets Layer (SSL) to establish connections to the database.

（A）XmlReader obj = (XmlReader)rdr[1];

（B）Type obj = (Type)rdr[1];

（C）SByte obj = (SByte)rdr[1];

（D）String obj = (String)rdr[1];

（A）Configure the navigation property to return a type that implements the IQueryable interface.

（B）Modify each mapped property to contain sealed and protected accessors.

（C）Modify each mapped property to contain non-sealed, public, and virtual accessors.

（D）Configure the navigation property to return a type that implements the ICollection interface.

（E）Configure the navigation property to return a type that implements the IEntityWithRelationships interface.

（A）SqlConnection cnn = new SqlConnection(strCnn); SqlCommand cmd = new SqlCommand(sql, cnn); cnn.Open(); { try { dr = cmd.ExecuteReader(); cnn.Close(); } catch {
throw;
}
}

（B）using(SqlConnection cnn = new SqlConnection(strCnn)) { try { SqlCommand cmd = new SqlCommand(sql, cnn); cnn.Open(); dr = cmd.ExecuteReader(); } catch {
throw;
}
}

（C）SqlConnection cnn = new SqlConnection(strCnn); SqlCommand cmd = new SqlCommand(sql, cnn); cnn.Open(); { try { dr = cmd.ExecuteReader(); } finally {
cnn.Close();
}
}

（D）SqlConnection cnn = new SqlConnection(strCnn); SqlCommand cmd = new SqlCommand(sql, cnn);
cnn.Open();
{
try
{
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{
cnn.Close();
throw;
}
}

（A）SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;

（B）SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;

（C）SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;

（D）SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;

（A）var parameter = new ObjectParameter("text", text + "%");
var result = context.CreateQuery<string>(
"SELECT VALUE (c.Name) FROM Colors AS c WHERE c.Name LIKE @text",
parameter);

（B）var parameter = new ObjectParameter("text", text + "%");
var result = context.CreateQuery<string>( "SELECT (c.Name) FROM Colors AS c WHERE c.Name LIKE @text", parameter);

（C）var parameter = new ObjectParameter("text", text + "%"); var result = context.CreateQuery<string>(
"SELECT VALUE (c.Name) FROM Colors AS c WHERE c.Name LIKE '@text'", parameter);

（D）var parameter = new ObjectParameter("text", HttpUtility.HtmlEncode(text) + "%"); var result = context.CreateQuery<string>(
"SELECT (c.Name) FROM Colors AS c WHERE c.Name LIKE '@text'@, parameter);