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

1. You create an e-commerce Web application.
During testing, you find bugs on the shopping cart page. You believe that the bugs might be related to the
values in the session or application state.
You need to see the session and application state values at the bottom of the page.
What should you do?

A) In the Web.config file, set the Trace enabled attribute to True.
B) In the Page_Load of the shopping cart page, add a Trace.Write for each session and application value that you need to see.
C) Add a WebListener to the system.diagnostics section of the Web.config file.
D) Add the Trace attribute to the @ Page directive and set it to True.

2. You have a Microsoft ASP.NET Web application. The application connects to a Microsoft SQL Server database. The database has a table named Product.
You write the following code segment to create a stored procedure named AddProduct.
CREATE PROCEDURE AddProduct
@Name VARCHAR(50)
AS
BEGIN
INSERT INTO Product(Name) VALUES(@Name);
RETURN SCOPE_IDENTITY();
END;
GO
You write the following code segment that will call the procedure to add a product. (Line numbers are included for reference only.)
01 Dim newProdID As Int32 = 0
02 Using conn As New SqlConnection(connString)
03 conn.Open()
04 Dim cmd As New SqlCommand("AddProduct", conn)
05 cmd.CommandType = CommandType.StoredProcedure
06 cmd.Parameters.Add("@Name", SqlDbType.VarChar)
07 cmd.Parameters("@Name").Value = newName
09 End Using
You need to retrieve the product ID of the new product.
Which code segment should you insert at line 08?

A) Try newProdID = DirectCast(cmd.ExecuteScalar(), Int32) Catch ex As Exception End Try
B) Try newProdID = DirectCast(cmd.ExecuteNonQuery(), Int32) Catch ex As Exception End Try
C) cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int) cmd.Parameters("@RETURN_VALUE").Direction = ParameterDirection.ReturnValue Try cmd.ExecuteNonQuery() newProdID = DirectCast(cmd.Parameters("@RETURN_VALUE").Value, Int32) Catch ex As Exception End Try
D) cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int) cmd.Parameters("@RETURN_VALUE").Direction = ParameterDirection.Output Try cmd.ExecuteNonQuery() newProdID = DirectCast(cmd.Parameters("@RETURN_VALUE").Value, Int32) Catch ex As Exception End Try

3. 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.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(); }
D) 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();

4. You create a Microsoft ASP.NET Web site.
The SqlProvider configuration of the Web.config file contains the following code fragment.
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="MySqlConnection"
applicationName="MyApplication" />
</providers> </membership>
You need to ensure that the Web site can store passwords securely. You also need to ensure that passwords can be retrieved.
Which code fragment should you add to the Web.config file?

A) passwordFormat="Encrypted" enablePasswordRetrieval="true" requiresQuestionAndAnswer="true"
B) passwordFormat="Clear" enablePasswordRetrieval="true" requiresQuestionAndAnswer="true"
C) passwordFormat="Hashed" enablePasswordReset="true" requiresQuestionAndAnswer="false"
D) passwordFormat="Encrypted" enablePasswordReset="true" requiresQuestionAndAnswer="true"

5. You want to enable users of a Web application to modify the Web application's UI and behavior.
These modifications must be maintained at the user level so that when users return to the Web application,
the changes are still in effect.
You need to achieve this goal by using the minimum amount of custom code.
What should you do?

A) Use Web Part controls.
B) Persist control data by using view state.
C) Enable session state on the Web application.
D) Maintain a profile for each user.

Solutions: