Visual Basic (VB) Question:

Download Job Interview Questions and Answers PDF

Name the four different locking type in ADO and describe them briefly.

Visual Basic (VB) Interview Question
Visual Basic (VB) Interview Question

Answer:

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. Can not alter the data.

Download Visual Basic (VB) Interview Questions And Answers PDF

Previous QuestionNext Question
Name the four different cursor types in ADO and describe them briefly.Describe Database Connection pooling (relative to MTS )?