1. In SQL Server - which of the following is not a control statement?

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

3. Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock column.

4. Which query will display data from the Pers table relating to Analysts - clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?

5. Which of the following is not a valid ASP.NET Web form control?

6. Evaluate the following SQL statement: SELECT e.employee_id - ( (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus))) AS CALC_VALUE FROM employees e - sales s WHERE e.employee_id = s.emp_id;? What will happen if all the parentheses are removed from the calculation?

7. How can you change "Hansen" into "Nilsen" in the LastName column in the Persons Table?

8. You are creating an ASP.NET application for AutoMart Internet Web site. A toolbar is required that will be displayed at the top of each page in the Web site. The toolbar will contain only static HTML code. The toolbar will be used in only AutoMart website. You plan to create the toolbar as a reusable component for your application. You need to create the toolbar in a minimum possible time. Which method will you adopt?

9. Is the FROM clause necessary in every SELECT statement?

10. You are creating an ASP.NET application that will run on your company's intranet. You want to control the browser window and respond immediately to non-post-back events. Which should you use?

11. You create an ASP.NET page that allows a user to enter a requested delivery date in a TextBox control named txtDelDate. The date must be no earlier than two business days after the order date - and no later that 60 business days after the order date. You add a CustomValidator control to your page. In the Properties window - you set the ControlToValidate property to txtDelDate. You need to ensure that the date entered in the txtDelDate TextBox control falls within the acceptable range of values. In addition - you need to minimize the number of round trips to the server. What should you do?

12. You need to implement a TextChanged event handler for MemberID. You want this event handler to retrieve information about a person by using an XML Web service that charges for each access. The page will then be redisplayed with additional information about the vehicle obtained from the XML Web service.

13. Which of the following connectionstring in Web.Config is correct if Microsoft SQL Server database named ClassList resides on a server named Neptune is to be used?

14. The sales database contains a customer table and an order table. For each order there is one and only one customer - and for each customer there can be zero or more orders. How should primary and foreign key fields be placed into the design of this database?

15. 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?

16. In ASP.NET - which of the following is not an event of the Page class?

17. You are creating an ASP.NET page for Premium Consultants. You create a GridView control that displays past purchases made by the user. The GridView control is populated from an existing database when the page is created. The page contains TextBox controls that allow users to update their personal information - such as address and telephone number. You need to ensure that the page is refreshed as quickly as possible when users update their contact information.

18. eriod for the cached data

19. Which of the following datatypes is not supported by SQL-Server?

20. What does the following line of code do?<%@ Register tagprefix="ril" Tagname="test" Src="rilTest.ascx" %>

21. Which of the following has the highest order of precedence in SQL Server?

22. Which of the following are false for ASP.NET events?

23. What is the total no. of events in Global.asax file in Asp.NET?

24. Choose the appropriate option with regard to the above queries.

25. You are creating an ASP.net application to enter timesheet data intuitively. Users will enter data using a DataGrid. You have added a button column to your DataGrid. The button column uses a custom button to allow users to initiate some calculations on the data in the grid. Which event does the DataGrid control raise when the custom button is clicked?