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?

A company has the following departments:

Marketing, Designing, production, Packing

What will be the result of the following query?

select * from table where department < 'marketing';

When designing a database table, how do you avoid missing column values for non-primary key columns?

You are using Visual Basic to retrieve class information from a Microsoft SQL Server database named ClassList. The database Resides on a server named Neptune. Which code fragment will create a connection to this data source?

Which of the following queries is valid?

You want to access data from the "Customer" table in the database. You generate a DataSet named "MyDataSet" by adding "Customer" table to it. Which of the following statements should you use to load the data from the database into "MyDataSet" which has been loaded with multiple tables, using a SqlDataAdapter named "MyAdapter"

Examine the query:-

select (2/2/4) from tab1; where tab1 is a table with one row.

This would give a result of:

In a SQL Server query, what will the output be if you try to perform arithmetic on NULL values?

Which operator will be evaluated first in the following statement?

select (age + 3 * 4 / 2 - 8) from emp

Examine the two SQL statements given below:

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC

What is true about them?

Examine the data in the EMPLOYEES table given below:

LAST_NAME  DEPTARTMENT_ID     SALARY

ALLEN                10                      3000

MILLER              20                     1500

King                   20                      2200

Davis                 30                      5000

Which of the following Subqueries work?

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?

Consider the transaction:

Begin Transaction

      Create table A ( x smallint, y smallint)

      Create table B ( p smallint, q smallint)

        Update A set x=600 where y > 700

        Update B set p=78 where q=99

          If @@ error != 0

          Begin

          RollBack Transaction

            Return

          End

     Commit Transaction

Select the correct option:

The STUDENT_GRADES table has these columns:

STUDENT_ID        INT

SEMESTER_END        DATETIME

GPA                FLOAT

Which of the following statements finds the highest Grade Point Average (GPA) per semester?

You use a Command object to retrieve employee names from the employee table in the database. Which of the following will be returned when this command is executed using ExecuteReader method?

Consider the following two tables:

1. customers( customer_id, customer_name)

2. branch ( branch_id, branch_name )

What will be the output if the following query is executed:

Select *, branch_name from customers,branch

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

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

Consider the following table structure of students:

rollno        int

name          varchar(20)

course        varchar(20)

What will be the query to display the courses in which the number of students enrolled is more than 5?

What will happen if you query the emp table as shown below:

select empno, DISTINCT ename, Salary from emp;

Which one of the following correctly selects rows from the table myTable that have null in column column1?

In SQL Server, which of the following is not a control statement?

Which of the following is the syntax for creating an Index?

How you will generate a report with minimum network traffic?

You are developing a website that has four layers. The layers are user interface (web pages), business objects, data objects, and database. You want to pass data from the database to controls on a web form. What should you do?

Which of the following is not a valid character datatype in SQL Server?

Which of the following statements about SQL Server comments is false?

Which of the following are not date parts?

Which one of the following must be specified in every DELETE statement?

Which of the following commands is used to change the structure of table?

What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?

What is the maximum value that can be stored for a datetime field?

How can you view the structure of a table named “myTable” in SQL Server?

What does referential integrity (also called relational integrity) prevent?

Which of the following is not a global variable?

Which of the following is not a valid binary datatype in SQL Server?

You create an ASP.NET page named ProjectCalendar.aspx that shows scheduling information for projects in your company. The page is accessed from various other ASP and ASP.NET pages hosted throughout the company's intranet. All employees on the intranet use Internet Explorer. ProjectCalendar.aspx has a Calendar control at the top of the page. Listed below the Calendar control is detailed information about project schedules on the data selected. When a user selects a date in the calendar, the page is refreshed to show the project schedule details for the newly selected date. Users report that after viewing two or more dates on ProjectCalendar.aspx, they need to click the browser's Back button several times in order to return to the page they were viewing prior to accessing ProjectCalendar.aspx.

 You need to modify ProjectCalendar.aspx so that the users need to click the Back button only once. What to do?

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?

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.

 What should you do?

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

In SQL Server, you should avoid the use of cursors because:

You need to install an online parcel tracking application and its supporting assemblies so that the application and its assemblies can be uninstalled using the Add/Remove Programs Control Panel applet. What should you do?

You are debugging a Visual Basic.NET application. You add a variable to the watch window. When Visual Basic enters break mode, the Value of the expression variable is "". What is the most likely cause of the problem?

You want to create a cookie object named "CustomerAddress" of type "CustomerInfo" to maintain address information of customers who buy products online. Which of the following code snippets should you use to create this cookie?

You are creating an ASP.NET application that will record each customer's entry. It is possible that thousands of entries could be posted at any given time. Your application will be hosted on twenty Web servers. As customers enter information into your application, maintaining state information will be important. This information should be stored securely and should be capable of being restored in the event that a Web server is restarted. Customers will enter data into three separate pages in your application. Which of the following methods of storing state information would best suit the situation?

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?

Consider the following ASP.NET events:

1. Page_Load
2. Page_Unload
3. Control Event
4. Page_Init

What is the order of their execution?

You create an ASP.NET page named Customer.aspx. Customer.aspx contains a Web user control that displays a drop-down list box of Cities. The Web user control is named CityList, and it is defined in a file named CityList.ascx. The name of the DropDownList control in City.ascx is CuCity. You try to add code to the Page.Load event handler for Customer.aspx, but you discover that you cannot access CuCity from code in Customer.aspx. You want to ensure that code within Customer.aspx can access properties of CuCity. What should you do?

You are creating an ASP.NET application. The application will be deployed on intranet. Application uses Microsoft Windows authentication. More than 100 users will use the ASP.NET application simultaneously. What setting should be done by the project manager regarding user authentication?

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?