.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Swati Kadam
Ashutosh Jha

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Post New Question Subscribe to Interview Questions
Quick Links For Interview Questions Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  OOPs  JQuery  JavaScript/VBScript
NetworkingAptitudeOthers  All    

Interview Questions And Answers

What is connection pooling and what is the maximum Pool Size in ADO.NET Connection String?

Author: Swati Kadam          Posted Date: September 17, 2014    Category: ADO.Net     Points: 40

A connection pool is created when a connection is opened the first time. The next time a connection is opened, the connection string is matched and if found exactly equal, the connection pooling would work.
Otherwise, a new connection is opened, and connection pooling won't be used.
Maximum pool size is the maximum number of connection objects to be pooled.
If the maximum pool size is reached, then the requests are queued until some connections are released back to the pool. It is therefore advisable to close the connection once done with it.

What is the difference between the Clone() and Copy() methods of the DataSet class?

Author: Swati Kadam          Posted Date: September 17, 2014    Category: ADO.Net     Points: 40

The Clone() method copies only the structure of a DataSet. The copied structure includes all the relation, constraint, and DataTable schemas used by the DataSet. The Clone() method does not copy the data, which is stored in the DataSet.

The Copy() method copies the structure as well as the data stored in the DataSet.

How does a content page differ from a master page?

Author: Swati Kadam          Posted Date: September 17, 2014    Category: ASP.Net     Points: 40

A content page does not have complete HTML source code; whereas a master page has complete HTML source code inside its source file.

How is body onload() function different from document.ready() function used in Jquery?

Author: Swati Kadam          Posted Date: September 17, 2014    Category: JQuery     Points: 40

Document.ready() function is different from body onload() function because off 2 reasons:
1. We can have more than one document.ready() function in a page where we can have only one onload function.
2. Document.ready() function is called as soon as DOM is loaded where body.onload() function is called when everything gets loaded on the page that includes DOM, images and all associated resources of the page.

What is the use of jquery load() method

Author: Ashutosh Jha          Posted Date: August 31, 2014    Category: JQuery     Points: 40

The jQuery load() method is a powerful AJAX method.
The load() method loads data from a server and puts the returned data into the selected element without reload the complate page.
Ex:The following example loads the content of the file "test.txt" into a specific <div> element

what are the main features of JQuery.

Author: Ashutosh Jha          Posted Date: August 31, 2014    Category: JQuery     Points: 40

Below are the main features of Jquery.

1. Animations can be easily applied.
2. Applying / Changing CSS.
3. Cool plugins.
4. Ajax support
5. DOM selection events
6. Event Handling

What are the HTTP Handlers and HTTP Modules

Author: Ashutosh Jha          Posted Date: August 31, 2014    Category: .NET Framework     Points: 40

HttpModule and HttpHandler are two components which comes with the HttpPipeLine while moving the request to HttpPipeLine. here HttpModule is used to check the request authentication and then routing so that it should be received by the correct handler(HttpHandler) for the process and then after processing , it validates the request and then route it back to the client.

How to check the performance of SQL queries.

Author: Ashutosh Jha          Posted Date: August 31, 2014    Category: Sql Server     Points: 40

Sql Queries performance can be checked by using the Query optimization. we can check the query execution plan that how much time the query is taking to execute and then we can find-out that which part of the query is taking more time. The issue could e incorrect joins which is leading for more time to get the results. or in-proper sub-queries. By query execution plan, we can track the execution of the queries and then optimize it if required.

what is SQL Profiler.

Author: Ashutosh Jha          Posted Date: August 31, 2014    Category: Sql Server     Points: 40

Sql Profiler is a tool in the Sql Server management Studio which is mainly used to track the data from the front end. It is used to see the actual execution of the queries, stored procedure for the input data. So by using this tool, we can check all the input data which is coming from the front end or from another queries and can validate that data against the actual data. This tool is mainly used for fixing the issues related to the database.

What is Group By Clause

Author: Ashutosh Jha          Posted Date: August 31, 2014    Category: C#     Points: 40

Group By clause is used to group the rows, depending upon one or more values so that the group function can be applied to each group. if the 'Where' clause exists in the select statement, then Group By clause always be followed to the 'Where' clause. If in the select statement, there are non-aggregate columns, then in the Group By clause we need to add all those columns except the aggregate columns.

« Previous12345678910….459460Next »

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend