1. How to check the condition in Msgbox?
If(Msgbox(Do you want to delete this Record,VbYesNo)=VbYes)Then End if

2. What are the type of validation available in VB?
Field, Form

3. What are two validate with Data Control?
Data_Validate, Data_Error.

4. What are types of binding?
Assigning variable with defined memory space.
Late Binding - Memory size is allotted in later stage.
Ex:- Dim x as object
Early Binding - Memory size is allotted while declaring itself. New Key word is important.
Ex:- Dim x as New Object

5. Record set types and Number available in VB?
1- Dynaset, 0 Table, 2 Snap Shot

6. DSN Less Connection?
Server=Oracle; Driver={Microsoft ODBC for Oracle};

7. Name and explain the different compatibility types when creating a COM component
No Compatibility ? New GUID created, references from other components will not workProject Compatibility ? Default for a new component Binary Compatibility ? GUID does not change, references from other components will work

8. Name the four different locking type in ADO and describe them briefly.
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.

9. What are the main components of the ADO object model? How are they used?
Connection: Used to make a connection between your app and an external data source, ie, sql server.Command: Used to build queries, including user-specific parameters, to access records from a data source (which are returned in a Recordset)Recordset:Used to access records returned from an SQL query. With a recordset, you can navigate returned records. You can also add, modify or delete records.

10. Handling Error in Calling chain.
This will call the top most error where the error is handled.