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

You create an ASP.NET application for an online insurance site PremiumInsurance. A page named PersonalDetails.aspx has the following Page directive:

<%@ Page Language="VB" CodeBehind="PersonalDetails.aspx.vb" AutoEventWireup="false" inherits="InsApp.PersonalDet"%> PersonalDetails.aspx had a TextBox control named MemberID in which the user can enter a Personal MemberID. The HTML code for this control is as follows: <asp:TextBox ID="MemberID" Columns="20" Runat="server"/> 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. You are implementing the TextChanged event handler. Which two courses of action should you take? (Each correct answer presents part of the solution. Choose two)

You create an ASP.NET application for ABC Corporation. The project manager requires a standard appearance for all Web applications. Standards are expected to change periodically. You need to enforce these standards and reduce maintenance time. What would you do?

Which of the following are not true in ASP.NET?

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?

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?

You are developing an application to take orders over the Internet. When the user posts back the order form, you first check to see whether he is a registered customer of your company. If not, you must transfer control to the Register html page. Which method should you use to effect this transfer?

Consider the following two statements relating to ASP.NET and choose the most appropriate option?

Statement 1: Value types are allocated on a stack

Statement 2: Reference types are allocated on a managed CLR Heap

How can you pop-up a window to display text that identifies the author of the book?

In ASP.NET, the control's value set during the postback can be accessed in?

Which of the following is not a service provided by Common Language Runtime (CLR)?

What does the following line of code do?

<%@ Register tagprefix="ril" Tagname="test" Src="rilTest.ascx" %>

What will happen if the Server configuration file and the Application configuration file have different values for session state?

What data types do the RangeValidator control support?

Which of following is correct if you want to import a C# class called myClass that is implemented in the myClass.cs file into a .aspx page?

Which DLL is responsible for processing the page requests running on the server?

In which of the following namespaces is the Assembly class defined?

Which of the following are the valid methods of the SqlTransaction class?

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

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

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

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

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

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

Which of the following directives can be used to include libraries in an ASP.NET page?

In ASP.NET, the exception handling should be used?

Which of the following scenarios are applicable to Window Workflow Foundation?

The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used?

Employee

---------

Empno

Employeename

Salary

Deptno

Department

---------

Deptno

Departname

Which of the following is not a valid SQL OPERATOR?

Consider the query:

SELECT name    

FROM Student    

WHERE name LIKE '_a%';

Which names will be displayed?

Examine the code given below:

SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000

Which of the following statements is correct with regard to this code?

Which of the following are aggregate functions in SQL?

What is the correct SQL syntax for selecting all the columns where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

It is time for the annual sales awards at your company. The awards include certificates awarded for the five sales of the highest sale amounts. You need to produce a list of the five highest revenue transactions from the Orders table in the Sales database. The Orders table is defined as follows:

CREATE TABLE Orders (        

OrderID Int IDENTITY NOT NULL,       

 SalesPersonID Int NOT NULL,       

 RegionID Int NOT NULL,        

OrderDate Datetime NOT NULL,        

OrderAmount Int NOT NULL )

Which statement will produce the report correctly?

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

Which of the following constraints can be used to enforce the uniqueness of rows in a table?

In which sequence are queries and sub-queries executed by the SQL Engine?

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?

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

What is the order of precedence among the following operators?

1. IN

2. NOT

3. AND

4. OR

The simplest query must include at least________ and _________?

You want to display the titles of books that meet the following criteria:

1. Purchased before November 11, 2002

2. Price is less than $500 or greater than $900

You want to sort the result by the date of purchase, starting with the most recently bought book.

Which of the following statements should you use?

Is the FROM clause necessary in every SELECT statement?

Is it possible to insert several rows into a table with a single INSERT statement?

Which line of code should you use to copy the edited rows from dataset productInfo into another dataset productChanges?

Consider the following queries:

1. select * from employee where department LIKE "[^F-M]%";

2. Select * from employee where department = "[^F-M]%";

Select the correct option:

What is wrong with the following query?

select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?

Examine the description of the STUDENTS table:

STD_ID                INT

COURSE_ID        VARCHAR (10)

START_DATE        DATETIME

END_DATE        DATETIME

The aggregate functions valid on the START_DATE column are:

Which of the following objects is required by the Dataset to retrieve data from a database and to save updated data back to the database?