Microsoft TS: Microsoft .NET Framework 2.0 - Web-based Client Development Sample Questions:

1. You are creating a Microsoft ASP.NET Web application that allows customers to transfer money between their bank accounts.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection cn = new SqlConnection())
02 {
03 cn.ConnectionString = strConnString;
04 cn.Open();
05 using (SqlTransaction tran = cn.BeginTransaction())
06 {
07 try
08 {
10 }
11 catch (Exception xcp)
12 {
13 lblMessage.Text = xcp.Message;
14 tran.Rollback();
15 }
16 }
17 }
You need to ensure that the transfer operation executes within a transaction.
Which code segment should you insert at line 09?

A) using (SqlCommand cmd = cn.CreateCommand())
{
cmd.Transaction = tran;
cmd.CommandText = "UPDATE Accounts SET Bal = Bal " + Xfer + " WHERE Acct = " + Acct1;
cmd.ExecuteNonQuery();
cmd.CommandText = "UPDATE Accounts SET Bal = Bal + " + Xfer + " WHERE Acct = " + Acct2;
cmd.ExecuteNonQuery();
}
tran.Commit();
B) using (SqlCommand cmd = cn.CreateCommand() { cmd.Transaction = tran; cmd.CommandText = "UPDATE Accounts SET Bal = Bal " + Xfer + " WHERE Acct = " + Acct1; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE Accounts SET Bal = Bal + " + Xfer + " WHERE Acct = " + Acct2; cmd.ExecuteNonQuery(); }
C) using (SqlCommand cmd = cn.CreateCommand()) { cmd.CommandText = "UPDATE Accounts SET Bal = Bal " + Xfer + " WHERE Acct = " + Acct1; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE Accounts SET Bal = Bal + " + Xfer + " WHERE Acct = " + Acct2; cmd.ExecuteNonQuery(); } tran.Commit();
D) using (SqlCommand cmd = cn.CreateCommand()) { cmd.CommandText = "UPDATE Accounts SET Bal = Bal " + Xfer + " WHERE Acct = " + Acct1; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE Accounts SET Bal = Bal + " + Xfer + " WHERE Acct = " + Acct2; cmd.ExecuteNonQuery(); }

2. You are creating a Microsoft ASP.NET Web site. The Web site has a Web page that contains the following code fragment.
<asp:Label ID="Label1" runat="server" Text="Hello 1" ForeColor="red" Font-
Italic="false" />
<asp:Label ID="Label2" runat="server" Text="Hello 2" ForeColor="red"
SkinId="Winter" />
You add a skin file to the MyTheme folder.
You need to ensure that the following requirements are met:
The font style of Label1 is italic and its foreground color remains red. The foreground color of Label2 is blue.
What should you do?

A) *Add the following attribute to the page directive. Theme="MyTheme" Add the following code fragment to the skin file. <asp:label runat="server" Font-Italic="true" /> <asp:label runat="server" ForeColor="blue" SkinId="Winter" />
B) *Add the following attribute to the page directive. StyleSheetTheme="MyTheme" Add the following code fragment to the skin file. <asp:label runat="server" Font-Italic="true" SkinId="Label1" /> <asp:label runat="server" ForeColor="blue" SkinId="Label2" />
C) *Add the following attribute to the page directive. StyleSheetTheme="MyTheme" Add the following code fragment to the skin file. <asp:label runat="server" Font-Italic="true" /> <asp:label runat="server" ForeColor="blue" SkinId="Winter" />
D) *Add the following attribute to the page directive. Theme="MyTheme" Add the following code fragment to the skin file. <asp:label runat="server" Font-Italic="true" /> <asp:label runat="server" ForeColor="blue" SkinId="Label2" />

3. You write a Web application. This application must support multiple languages.
You store the localized strings in the application as resources.
You want these resources to be accessed according to a user's language preference.
You create the following resource files in the App_GlobalResources folder of your application.
myStrings.resx myStrings.en-CA.resx myString.en-US.resx myStrings.fr-CA.resx myStrings.es-MX.resx
Each resource file stores a localized version of the following strings: Name, E-mail, Address, and Phone.
You create a Web Form that contains one label for each of these strings.
You need to ensure that the correct localized version of each string is displayed in each label, according to a user's language preference.
What should you do?

A) Set the directive for each page in your site as follows: <%@ Page UICulture="Auto" %>
B) Add the following code segment to the page's load event. lblName.Text = "{myStrings}Name" lblAddress.Text = "{myStrings}Address" lblEmail.Text = "{myStrings}Email" lblPhone.Text = "{myStrings}Phone"
C) Add the following code segment to the page's load event. lblName.Text = Resources.myStrings.Name lblAddress.Text = Resources.myStrings.Address lblEmail.Text = Resources.myStrings.Email lblPhone.Text = Resources.myStrings.Phone
D) Add the following configuration section to the Web.config file. <globalization culture="Auto" />

4. You load an XmlDocument named doc with the following XML.
<bookstore>
<books>
<book genre="reference" >
<title>Dictionary</title>
</book>
<book genre="reference" >
<title>World Atlas</title>
</book>
</books>
</bookstore>
You need to change the value for the genre attribute to NA for all book attributes.
First, you add the following code segment to your class.
XmlElement root = doc.DocumentElement;
XmlNodeList nodes = root.SelectNodes("books/book");
Which additional two code segments can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A) foreach (XmlNode node in nodes){ XmlNode genre = node.SelectSingleNode("@genre"); genre.Value = "NA"; }
B) foreach (XmlNode node in nodes){ node.Attributes[0].Value = "NA"; }
C) foreach (XmlNode node in nodes){ XmlNode genre = node.SelectSingleNode("/genre"); genre.Value = "NA"; }
D) foreach (XmlNode node in nodes){ XmlNode genre = node.SelectSingleNode("genre"); genre.Value = "NA"; }
E) foreach (XmlNode node in nodes){ node.Attributes[1].Value = "NA"; }

5. You write a class to interact with a database. The class uses a SqlConnection instance.
You need to detect when the state of the connection has been modified.
What should you do?

A) Write a method to override the SqlConnection.State property.
B) Write a method to handle the SqlConnection.Disposed event.
C) Write a method to handle the SqlConnection.StateChange event.
D) Write a method to handle the SqlConnection.InfoMessage event.

Solutions: