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


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

Disadvantage of Cursor ?

Posted By :Rahul     Posted Date :February 22, 2009    Points :10   Category :Sql Server 
Cursor plays there row quite nicely but although there are some disadvantage of Cursor .Because cursor doing roundtrip it will make network line busy and also make time consuming methods. First of all select query gernate output and after that cursor goes one by one so roundtrip happen.


Another disadvange of cursor are ther are too costly because they require lot of resources and temporary storage so network is quite busy.

You can also find related Interview Question to Disadvantage of Cursor ?  below: 

Write Some Disadvantage Of Cursor ?

  
Cursor plays there row quite nicely but although there are some disadvantage of Cursor .
Because we know cursor doing roundtrip it will make network line busy and also make time consuming methods. First of all select query gernate output and after that cursor goes one by one so roundtrip happen.Another disadvange of cursor are ther are too costly because they require lot of resources and temporary storage so network is quite busy. (More...)

Disadvantage in File Processing System?

  
1.Data redundancy & inconsistency.
2.Difficult in accessing data.
3.Data isolation.
4.Data integrity.
5.Concurrent access is not possible.
6.Security Problems. (More...)

What is Cursor?

  
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time.
In order to work with a cursor we need to perform some steps in the following order:
. Declare cursor
. Open cursor
. Fetch row from the cursor
. Process fetched row
. Close cursor
. Deallocate cursor

Shashi Ray (More...)

What is a cursor?

  
A cursor is used to access the result set stored in the memory on execution of a query. It is a special programming construct that allows data to be manipulated on a row-by-row basis. They point to a certain location within a record set and allow the operator to move forward (and sometimes backward, depending upon the cursor type) through the results one record at a time (More...)

Explain the disadvantage of ajax related to browser integration?

  
Dynamically created pages created by ajax does not support back button which takes the user to the previous pages. There are various solutions to this problem out of which one solution is to use iframes. Also users can bookmark a certain application in its state. User can maintain the applications as the state of the application changes (More...)

What is the main disadvantage of using IIS to host a service?

  
Using IIS to host your services means that you will not be able to support non-HTTP protocols such as TCP, named pipes, and MSMQ. You will have access to the many built-in features available with IIS such as process recycling and messagebased
activation. (More...)

Disadvantage of Single Node Topology?

  
1. Network consists of single device

2. Dumb terminal is dependent on server (More...)

Disadvantage Bus topology?

  
1. If backbone breaks, entire network gets down

2. Difficult to isolate problems

3. Limited number of devices (More...)

Disadvantage Star Topology?

  
1. Requires more cable .

2. Failure of hub affects entire network.

3. More Expensive. (More...)

Disadvantage of Ring Topology?

  
1. More cabling is required compared to bus.

2. One faulty device affects the entire network.

3. Addition of devices affect network. (More...)

Disadvantage of Mesh Topology?

  
1. Difficult to install and manage.

2. Each link from one device to other requires individual NIC.

3. Very much expensive. (More...)

Disadvantage in File Processing System in SQL Server?

  
Disadvantage in File Processing System in .SQL Server are

Less stability
Difficult in accessing data.
Data redundancy & inconsistency.
Data isolation and integrity.
Concurrent access is not possible.
Security Problems. (More...)

what is a cursor

  
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. For example, you can use cursor to include a list of all user databases and
make multiple operations against each database by passing each database name as a variable (More...)

what is Cursor?

  
Cursor is nothing but a temporary memory on database server,which stores result set temporary
Cursror memory allocated in tempdb
Cursor allows you to process the result row by row.

(More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

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

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


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