You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
The application uses nested transaction scopes. An inner transaction scope contains code that inserts
records into the database.
You need to ensure that the inner transaction can successfully commit even if the outer transaction rolls
back.
What are two possible TransactionScope constructors that you can use for the inner transaction to achieve
this goal?
(Each correct answer presents a complete solution. Choose two.)

• A. TransactionScope(TransactionScopeOption.Suppress)
• B. TransactionScope(TransactionScopeOption.RequiresNew)
• C. TransactionScope(TransactionScopeOption.Required)
• D. TransactionScope()

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create a Database Access Layer (DAL) that is database-independent. The DAL includes the following
code segment.
(Line numbers are included for reference only.)
01 static void ExecuteDbCommand(DbConnection connection)
02 {
03 if (connection != null){
04 using (connection){
05 try{
06 connection.Open();
07 DbCommand command = connection.CreateCommand();
08 command.CommandText = "INSERT INTO Categories (CategoryName)
VALUES ('Low Carb')";
09 command.ExecuteNonQuery();
10 }
11 ...
12 catch (Exception ex){
13 Trace.WriteLine("Exception.Message: " + ex.Message);
14 }
15 }
16 }
17 }
You need to log information about any error that occurs during data access.
You also need to log the data provider that accesses the database. Which code segment should you insert
at line 11?

• A. catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• B. catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• C. catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }
• D. catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. You add the following store procedure
to the database.
CREATE PROCEDURE GetProducts AS BEGIN
SELECT ProductID, Name, Price, Cost FROM Product END
You create a SqlDataAdapter named adapter to execute the stored procedure. You need to fill a DataTable
instance with the first 10 rows of the result set.
What are two possible code segments that you can use to achieve the goal?

• A. DataSet ds = new DataSet(); adapter.Fill(ds, 0, 10, "Product");
• B. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); adapter.Fill(0, 10, dt);
• C. DataSet ds = new DataSet(); ds.ExtendedProperties["RowCount"] = 10; ds.ExtendedProperties["RowIndex"] = 0; adapter.Fill(ds);
• D. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); dt.ExtendedProperties["RowCount"] = 10; dt.ExtendedProperties["RowIndex"] = 0; adapter.Fill(dt);

The application populates a DataSet object by using a SqlDataAdapter object.
You use the DataSet object to update the Categories database table in the database. You write the
following code segment.
(Line numbers are included for reference only.)
01 SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID,
CategoryName FROM Categories", connection);
02 SqlCommandBuilder builder = new SqlCommandBuilder(dataAdpater);
03 DataSet ds = new DataSet();
04 dataAdpater.Fill(ds);
05 foreach (DataRow categoryRow in ds.Tables[0].Rows)
06 {
07 if (string.Compare(categoryRow["CategoryName"].ToString(), searchValue,
true) == 0)
08 {
09 ...
10 }
11 }
12 dataAdpater.Update(ds);
You need to remove all the records from the Categories database table that match the value of the
searchValue variable.
Which line of code should you insert at line 09?

• A. ds.Tables[0].Rows.RemoveAt(0);
• B. ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();
• C. ds.Tables[0].Rows.Remove(categoryRow);
• D. categoryRow.Delete();