What is the correct order of clauses in the select statement?

1        select
2        order by
3        where
4        having
5        group by

Your company, StoreIt Inc has stored the text of several journals in a Microsoft SQL Server 7.0 database. Each sentence is stored in a separate record so that the text can be retrieved with the finest granularity. Several of these works are many thousands of printed pages in length. You are building a Web application that will allow registered users to retrieve data from these volumes. When a user of your Web application requests large amounts of text, your application must return it in the most efficient manner possible. How should you build the large String object that is required to provide the most efficient response to the user?

XYZ is creating an e-commerce site for PremiumBoutique. The site is distributed across multiple servers in a Web farm. Users will be able to navigate through the pages of the site and select products for purchase. XYZ wants to use a DataSet object to save their selections. Users will be able to view their selections at any time by clicking a Shopping Cart link. XYZ wants to ensure that each user's shopping cart DataSet object is saved between requests when the user is making purchases on the site. How can this requirement be implement?

In Windows built-in authentication, what will happen with the following set of statements?

You are debugging an ASP.NET application for Premium Corp.. Users will use the application to produce reports. Your application contains several Debug.WriteLine statements. Which window in Visual Studio .NET should you use to inspect output from the Debug.WriteLine statements?

You are creating an ASP.NET application that is hosted on your company's Web server. You want to access a database with minimal effort. What you will not do?

When you make some changes to the configuration file, do you need to stop and start IIS to apply the new settings?

Consider the following two statements and choose the most appropriate option: 1. For configuration, ASP.NET uses IIS Metabase 2. For configuration, ASP.NET uses an XML based configuration system

How can you view the results of Trace.Write() statements?

Which of the following is the way to handle Unmanaged Code Exceptions in ASP.NET?

Which of the following is not a valid directive in ASP.NET?