Name the four different cursor and locking types in ADO ?



Name the four different cursor and locking types in ADO ?..

Answer / guest

CURSORS::
*********
The cursor types are listed from least to most resource
intensive.
Forward Only - Fastest, can only move forward in recordset
Static - Can move to any record in the recordset. Data is
static and never changes.
KeySet - Changes are detectable, records that are deleted
by other users are unavailable, and records created by
other users are not detected
Dynamic - All changes are visible.

LOCKING TYPES::
****************
LockPessimistic - Locks the row once after any edits occur.
LockOptimistic - Locks the row only when Update is called.
LockBatchOptimistic - Allows Batch Updates.
LockReadOnly - Read only. Cannot alter the data.

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More Visual Basic Interview Questions

Difference between Recordset and Resultsets.

0 Answers  


Specify technical & functional architecture of your last 2 projects.

0 Answers  


what are the Differences between ActiveX Control and Standard Control?

0 Answers   Wipro,


What is the difference between Property Get, Set and Let.

1 Answers  


What are the uses of List View Control?

0 Answers   Atul Auto,






What is DAO?

0 Answers  


___,_____ and ____ container objects.

0 Answers  


What is meant by Establish Connection in RDO?

0 Answers  


Which property of textbox cannot be changed at runtime?

1 Answers  


what are the Differences between Recordset and Resultsets?

0 Answers   IBS, Lava International,


Is it possible to change menu runtime using API? If yes? Specify the function names.

0 Answers  


In visual source safe if in middle of my program power was off and it was not save then wat will happen whether it will save or not? can any body tel me the answer for this.

8 Answers   Wipro,


Categories