You work as a Windows Application Developer for ABC Inc. The company uses Visual Studio .NET as its application development platform. You create a Windows application using the .NET Framework. You create a database to maintain the record of the students. You create a table named Student. You want to retrieve names and roll number of those students whose age is less than ten years. An instance of the SqlCommand class named StudentCommand is already created. Which of the following code segments should you use to execute the query?

• A. StudentCommand.CommandType = CommandType.StoredProcedure;
  StudentCommand.CommandText = "Name and Roll number of students less than ten years";
• B. StudentCommand.CommandText = CommandText.Text;
  StudentCommand.CommandType = "SELECT Name, Roll number FROM Student WHERE Age <
  10";
• C. StudentCommand.CommandType = CommandType.StoredProcedure;
  StudentCommand.CommandText = "SELECT Name, Roll number FROM Student WHERE Age <
  10";
• D. StudentCommand.CommandType = CommandType.Text;
  StudentCommand.CommandText = "SELECT Name, Roll number FROM Student WHERE Age <
  10";

You work as a Software Developer for ABC Inc. The company uses Visual Studio .NET 2008 as its application development platform. You create an ASP.NET Web application using .NET Framework 3.5. The application is hosted on Microsoft Windows Server 2008. Only FTP access is available to the server. You need to improve the searching of the pages in the search engines by taking action to URLs that do not have an .aspx file extension. You must ensure that all pages as well as static content can also be requested. What will you do to accomplish this?

• A. Use an HttpHandler object.
• B. Use an HttpModule object.
• C. Use a Request object.
• D. Use an ISAPI filter.

Mark works as a Web Developer for ABC Inc. He develops an ASP.NET application, named MyApp1, using Visual Studio .NET. MyApp1 allows users to view and purchase company products.
It includes several pages. The start-up page of the application is Page1.aspx. He configures the
application's Web.config file to use form-based authentication.
Mark wants users to log on to Page1.aspx by providing their user names and passwords. To
accomplish this, he creates an ASP.NET page named UsersLogIn.aspx that allows each user to
specify a user name and password. He then writes the following syntax in the Web.config filE.
<authentication mode="Forms">
<forms name="MyName"
loginUrl="/UsersLogIn.aspx"
protection="All"
timeout="60"
slidingExpiration="true">
</forms>
</authentication>
What will be the result?
Each correct answer represents a part of the solution. Choose two.

• A. The session will never expire.
• B. The session will expire after 60 hours.
• C. The session will expire after 60 seconds.
• D. The session lifetime will be reset periodically.
• E. The session will expire after 60 minutes.
• F. Once the session lifetime is set, it will not change.

Which of the following is a reference type in Visual C#?

• A. structures
• B. primitive types
• C. strings
• D. enums

John works as a Web developer for HiTech Inc. He develops an application named MyApp by using Visual C# .NET. John uses a SQL Server database. He writes the following code:
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "UPDATE Employees SET Rank = 'Senior' WHERE Basic > 10000"; cmd.ExecuteNonQuery();
Now he wants to improve the performance of the program code. Which of the following actions will he perform to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

• A. Use a Cache object to execute the program code.
• B. Use a stored procedure instead of the CommandText property.
• C. Use database indexing.
• D. Use an OleDbDataReader object to execute the program code.
• E. Use a SqlCommand object instead of an OleDbCommand object.
• F. Use the Prepare method on the OleDbCommand object before executing the program code.