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

1. You have a Microsoft ASP.NET Web site.
The site allows users to select a theme to use while they are browsing the site.
You need to ensure that the selected theme is applied only to pages browsed during the user's current visit.
Where should you store the selected theme?

A) in the View State
B) in the Session State
C) in the page cache
D) in the Application State

2. 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) Add the Trace attribute to the @ Page directive and set it 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) In the Web.config file, set the Trace enabled attribute to True.

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 cn As New SqlConnection()
02 cn.ConnectionString = strConnString
03 cn.Open()
04 Using tran As SqlTransaction = cn.BeginTransaction()
05 Try
07 Catch xcp As Exception
08 lblMessage.Text = xcp.Message
09 tran.Rollback()
10 End Try
11 End Using
12 End Using
You need to ensure that the transfer operation executes within a transaction.
Which code segment should you insert at line 06?

A) Using cmd As SqlCommand = 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() End Using tran.Commit()
B) Using cmd As SqlCommand = 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() End Using tran.Commit()
C) Using cmd As SqlCommand = 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() End Using
D) Using cmd As SqlCommand = 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() End Using

4. 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) 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
B) Try newProdID = DirectCast(cmd.ExecuteScalar(), Int32) Catch ex As Exception End Try
C) Try newProdID = DirectCast(cmd.ExecuteNonQuery(), 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

5. You are creating a Microsoft ASP.NET Web site.
The Web site includes a page named Page1.aspx that uses a code-behind file. The code-behind file of
Page1.aspx page contains proprietary code.
You need to deploy the Web site. You also need to ensure that the code for Page1.aspx is not deployed.
What should you do?

A) Use the Publish Web Site tool, and then save the results to a local folder. Deploy the local folder to the Web host by using an FTP tool.
B) Use the aspnet_regiis command-line tool.
C) Build the Web site and save the results to a local folder. Deploy the local folder to the Web host by using an FTP tool.
D) Use the Copy Web Site tool.

Solutions: