Role-specific Visual Basic (VB) Interview Questions & Answers:

1. DSN Less Connection in VB?

"Server=Oracle; Driver={Microsoft ODBC for Oracle};"

2. Calling Stored Procedures in VB?

1. Calling Simply the Procedure with out Arguments "Call ProcedureName}"
2. If it is with Arguments Means then
Declare the Query Def qy
Set Qy as New Query def
Qy.SQL = "{Call ProcedureName(?

3. What is the max size allowed for Msgbox Prompt and Input Box?

1024

4. what will be the result for 15/4 and 154 ?

15/4 = 3.75 and 154 = 3

5. What is the max size allowed for Max label caption length?

2,048

6. How many procedures are in VB?

2.
function and sub procedures

7. What is the max size allowed for Max Control Names length?

255

8. Record set types and Number available in VB?

3.
1- Dynaset, 0 Table, 2 Snap Shot.

9. What is the max size allowed for Max Text box length.

32,000

10. What is ADO? What are its objects ?

ActiveX Data Object. ADO can access data from both flat files as well as the databases. I.e., It is encapsulation of DAO, RDO, and OLE that is why we call it as OLE-DB Technology. Objects are Connection, Record Set, Command, Parameter, field, Error, Property.