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

How do I call a DLL?

0 Answers  


What type of record sets are available in ADO?

4 Answers  


What is database vb?

0 Answers  


What does Addressof operator do?

1 Answers  


What is Static Variable?

3 Answers  


which arguments will be used to run a executable program in shell function ?

1 Answers  


Difference between Linked Object and Embedded Object?

0 Answers  


What is the tool used to configure the port range and protocols for DCOM communications?

1 Answers   IBM,


Scope of API?s can be of different types, what are they Why API functions are Required?

0 Answers  


What is ActiveX Document?

0 Answers   HCL,


what is the diff between inprocess and out of process ?

1 Answers  


What is Implicit?

1 Answers  


Categories