You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. You use Entity SQL to retrieve data from the
database.
You need to find out whether a collection is empty. Which entity set operator should you use?

• A. EXCEPT
• B. EXISTS
• C. ANYELEMENT
• D. IN

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Which one of these samples it the correct way to close the connection using Command Behavior?

• A. SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Console.WriteLine("{0}", rdr);
• B. SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); conn.Close(); Console.WriteLine("{0}", rdr);
• C. SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); rdr.Close(); Console.WriteLine("{0}", rdr);
• D. using (SqlDataReader rdr = new SqlDataReader())
  {
  string sql = @"sql statement";
  SqlConnection conn = connection.GetConnection();
  SqlCommand cmd = new SqlCommand(sql, conn);
  SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  Console.WriteLine("{0}", rdr);
  }

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a multi-tier application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
The model contains entities named SalesOrderHeader and SalesOrderDetail.
For performance considerations in querying SalesOrderHeader, you detach SalesOrderDetail entities from
ObjectContext.
You need to ensure that changes made to existing SalesOrderDetail entities updated in other areas of your
application are persisted to the database.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Call ObjectContext.ApplyCurrentValue.
• B. Call ObjectContext.ApplyOriginalValue.
• C. Re-attach the SalesOrderDetail entities.
• D. Set the MergeOption of SalesOrderDetail to MergeOptions.NoTracking.
• E. Set the MergeOption of SalesOrderDetail to MergeOptions.OverwriteChanges.

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database.
The application has two DataTable objects that reference the Customers and Orders tables in the
database.
The application contains the following code segment. (Line numbers are included for reference only.)
01 DataSet customerOrders = new DataSet();
02 customerOrders.EnforceConstraints = true;
03 ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04 customerOrders.Tables
["Customers"].Columns["CustomerID"],
05 customerOrders.Tables["Orders"].Columns
["CustomerID"]);
06 ...
07 customerOrders.Tables["Orders"].Constraints.Add(ordersFK);
You need to ensure that an exception is thrown when you attempt to delete Customer records that have related Order records.
Which code segment should you insert at line 06?

• A. ordersFK.DeleteRule = Rule.Cascade;
• B. ordersFK.DeleteRule = Rule.SetNull;
• C. ordersFK.DeleteRule = Rule.None;
• D. ordersFK.DeleteRule = Rule.SetDefault;

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases.
All updates for a given record are performed in a single transaction. You need to ensure that all transactions
can be recovered. What should you do?

• A. Call the RecoveryComplete method of the TransactionManager class.
• B. Call the EnlistDurable method of the Transaction class.
• C. Call the EnlistVolatile method of the Transaction class.
• D. Call the Reenlist method of the TransactionManager class.

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).