You use Microsoft .NET Framework 4 to develop an application. You use the XmlReader class to load
XML from a location that you do not control. You need to ensure that loading the XML will not load
external resources that are referenced in the XML. Which code segment should you use?

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database. You add the following table to the database.
CREATE TABLE Orders(
ID numeric(18, 0) NOT NULL,
OrderName varchar(50) NULL,
OrderTime time(7) NULL,
OrderDate date NULL)
You write the following code to retrieve data from the OrderTime column. (Line numbers are
included for reference only.)
01 SqlConnection conn = new SqlConnection (…) ;
02 conn.Open();
03 SqlCommand cmd = new SqlCommand(
“SELECT ID, OrderTime FROM Orders”, conn);
04 SqlDataReader rdr = cmd.ExecuteReader(); 05
06 while(rdr.Read())
07 {08
09 }
You need to retrieve the OrderTime data from the database.
Which code segment should you insert at line 08?

You use Microsoft .NET Framework 4 to develop an application. You write the following code to
update data in a Microsoft SQL Server 2008 database. (Line numbers are included for reference
only.)

01 private void ExecuteUpdate (SqlCoiranand cmd,
string connString, string updateStrnt)
02 {
03
04 }
You need to ensure that the update statement executes and that the application avoids connection
leaks.
Which code segment should you insert at line 03?

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 200B database. You need to ensure that the application connects to the database server by
using SQL Server authentication. Which connection string should you use?