Visual Basic Interview Online Test
Technical interview questions and answers are important for a Visual Basic Interview because many companies still use VB for maintaining legacy applications, automation tasks, and Windows-based tools. Recruiters expect candidates to understand syntax, variables, loops, functions, event-driven programming, and form design. Visual Basic remains relevant for industries that rely on older but stable systems, so questions from VB often appear in interviews at companies like TCS, Infosys, Wipro, Cognizant, and Accenture. This guide includes frequently asked Visual Basic interview questions with simple, clear explanations that help freshers and job seekers prepare effectively. These questions will strengthen your understanding of VB fundamentals and improve your performance in both technical rounds and project discussions during campus placements.
1. How do you register a component?
Answer: Compiling the component, running REGSVR32 MyDLL.dll
Show Answer
Hide Answer
2. Name and explain the different compatibility types when creating a COM component
Answer: 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
Show Answer
Hide Answer
3. Why is it important to use source control software for source code?
Answer: Modification history.Code ownership: Multiple people can not modify the same code at the same time.
Show Answer
Hide Answer
4. What two methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?
Answer: SetComplete and SetAbort.
Show Answer
Hide Answer
5. What is the tool used to configure the port range and protocols for DCOM communications?
Answer:
DCOMCONFIG.EXE
Show Answer
Hide Answer
6. What does Option Explicit refer to?
Answer: All variables must be declared before use. Their type is not required.
Show Answer
Hide Answer
7. What are the different ways to Declare and Instantiate an object in Visual Basic 6?
Answer: Dim obj as OBJ.CLASS with eitherSet obj = New OBJ.CLASS orSet obj = CreateObject(OBJ.CLASS?) orSet obj = GetObject( , OBJ.CLASS?)orDim obj as New OBJ.CLASS
Show Answer
Hide Answer
8. Name the four different cursor types in ADO and describe them briefly.
Answer: 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 detectedDynamic ? All changes are visible.
Show Answer
Hide Answer
9. Name the four different locking type in ADO and describe them briefly.
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.
Show Answer
Hide Answer
10. Describe Database Connection pooling (relative to MTS )?
Answer: This allows MTS to reuse database connections. Database connections are put to sleep as opposed to being created and destroyed and are activated upon request.
Show Answer
Hide Answer
11. What are the ADO objects?
Answer: Provide a scenario using three of them to return data from a database. Expected answer: Connection Connects to a data source; contains the Errors collectionCommand Executes commands to the data source. Is the only object that can accept parameters for a stored procedure.Recordset The set of data returned from the database.Scenario: There are many possibilities. The most likely is as follows:Dim conn As ADODB.ConnectionDim rs As ADODB.RecordsetDim Cmd As ADODB.Commandconn.ConnectionString = ?CONN
Show Answer
Hide Answer
12. Under the ADO Command Object, what collection is responsible for input to stored procedures?
Answer: The Parameters collection.
Show Answer
Hide Answer
13. What are some benefits of using MTS?
Answer: Database Pooling, Transactional operations, Deployment, Security, Remote Execution.
Show Answer
Hide Answer
14. What is the benefit of wrapping database calls into MTS transactions?
Answer: If database calls are made within the context of a transaction, aborting the transaction will undo and changes that occur within that transaction. This removes the possibility of stranded, or partial data.
Show Answer
Hide Answer
15. Describe and In Process vs. Out of Process component. Which is faster?
Answer: An in-process component is implemented as a DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component.Each client app that uses the component starts a new instance of it.An out of process component is implemented as an EXE, and unlike a dll, runs in its own process space. As a result, exes are slower then dlls because communications between client and component must be marshalled across process boundaries. A single instanc
Show Answer
Hide Answer
16. What are the main components of the ADO object model? How are they used?
Answer: 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.
Show Answer
Hide Answer
18. Dim x, y as integer. What is x and y data type?
Answer: X as variant and y as integer.
Show Answer
Hide Answer
19. What is Centralization Error Handling?
Answer: Writing function and calling it when error occurs.
Show Answer
Hide Answer
20. What is frx?
Answer: When some controls like grid and third party control placed in our application then it will create frx in run time.
Show Answer
Hide Answer
22. Why we use Treeview Control?
Answer: To list the hierarchical list of the node objects. Such of files and Directories.
Show Answer
Hide Answer
23. Handling Error in Calling chain.
Answer: This will call the top most error where the error is handled.
Show Answer
Hide Answer
24. In project properties if we set Unattended what is it mean?
Answer: This cannot have user interface. This can be used for the COM creation.
Show Answer
Hide Answer
25. What is the size of the variant data type?
Answer: The Variant data type has a numeric storage size of 16 bytes and can contain data up to the range of a Decimal, or a character storage size of 22 bytes (plus string length),and can store any character text.
Show Answer
Hide Answer
26. What is view Port?
Answer: The area under which the container provides the view of the ActiveX Document is known as a view port.
Show Answer
Hide Answer
28. What is the diff between the Std and Class Module?
Answer: Std Global with in the project. Cls Global through out the all project only thing is we want to set the type lib. Class Modules can be Instantiated.
Show Answer
Hide Answer
30. Drag and Drop state numbers and functions?
Answer:
State 0 Source control is being dragged with the range of a target.
1 Out of the range of a target.
2 One position in the target to another.
Show Answer
Hide Answer
31. What are the Style Properties of Combo Box?
Answer: Simple, Dropdown list We can type and select. Dropdown Combo Only Drop Down.
Show Answer
Hide Answer
32. What are the Style properties of List Box?
Answer: Simple Single Select , Extended. Multiple Select.
Show Answer
Hide Answer
33. What is Collection Objects?
Answer: Similarly to arrays but is preferred over an array because of the following reasons.
1. A collection objects uses less Memory than an array.
2. It provides methods to add and delete members.
3. It does not required reason statement when objects are added or deleted.
4. It does not have boundary limitations.
Show Answer
Hide Answer
34. What is the difference between Property Get, Set and Let?
Answer: Set Value is assigned to ActiveX Object from the form.
Let Value is retried to ActiveX Object from the form.
Get- Assigns the value of an expression to a variable or property.
Show Answer
Hide Answer
35. How to change the Mouse Pointer?
Answer: Screen.MousePointer = VBHourGlass/VBNormal.
Show Answer
Hide Answer
38. What are the record set types?
Answer: RdOpenFowardOnly 0 (Default used only for the read only purpose)
RdOpenStatic 1
RdOpenDynamic 2
RdOpenKeySet 3 (Normally used for the live project)
Show Answer
Hide Answer
39. What is the diff between RDO and ADO?
Answer: RDO is Hierarchy model where as ADO is Object model. ADO can access data from both flat files as well as the data bases. I.e., It is encapsulation of DAO, RDO , OLE that is why we call it as OLE-DB Technology.
Show Answer
Hide Answer
40. Diff types of Lock Types?
Answer: RdConcurReadOnly 0 (Default)
RdConcurLock 1 (Pessimistic Locking)
RdConcurRowver 2 (Optimistic Lociking)
RdConcurValues 3
RdConcurBatch 4
Show Answer
Hide Answer
42. Have you create Properties and Methods for your own Controls?
Answer: Properties Public variable of a Class
Method Public procedure of a class
Show Answer
Hide Answer
44. Different type of Instantiation?
Answer: Private Only for the Specific Module.
Public not creatable Private & Public
Multi Use - Variable we have to declare.
Single Use Not possible through dll.
Global Multiuse Have variable not Required to Declare.
Global Single Use - Only for exe.
Show Answer
Hide Answer
45. What are the different types of Dialog Box?
Answer: Predefined, Custom, User Defined.
Show Answer
Hide Answer
46. What is Seek Method which type of record set is available this?
Answer: Only in DbOpenTables.
Syntax: rs.index = "empno"
rs.seek "=" , 10
If with our setting the rs.index then run time error will occur.
Show Answer
Hide Answer
47. What is Zorder Method?
Answer: Object.Zorder = 1 or 0 Place a Specified mdiform form or control at the front or back of the z-order with n its Graphical Level.
Show Answer
Hide Answer
48. Can us able to set Instancing properties like Singleuse, GlobalSingleuse to ActiveXDll?
Answer: No.
Show Answer
Hide Answer
49. What are properties available in Clip Board?
Answer: No Properties Available. Only the methods they are SetText, GetText, Setdata(), Getformat(), Clear.
Show Answer
Hide Answer
50. What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?
Answer: Microsoft ODBC driver will support all the methods and properties of Visual Basic. Where as the Oracle not.
Show Answer
Hide Answer
51. What the RDO Methods and Events?
Answer: Methods Events
Begin Trans Validate
Commit Trans Reposition
Rollback Trans Error
Cancel Query Complied
Refresh
Update Controls
Update row
Show Answer
Hide Answer
54. Diff type of Datatypes?
Answer: LOB (Large Object Data type).
CLOB (Stores Character Objects).
BLOB ( Store Binary Objects such as Graphic, Video Chips and Sound files).
BFILE(Store file pointers to LOB It may Contain filename for photos store on CD_ROM).
Show Answer
Hide Answer
55. What is Tabstrip control?
Answer: Libraries of procedure external to the application but can be called from the application.
Show Answer
Hide Answer
56. What is Static Variable?
Answer: Its Scope will be available through out the life time.
Show Answer
Hide Answer
58. What is the starting Index value? How to locate it?
Answer: It is tab control to place our controls with in the form in multiple sheets.
Index starts with 1.
And to identify If Tabstrip1.SelectedItem.
Index = 1 Then ..
End if
Show Answer
Hide Answer
59. What is Parser Bug?
Answer: It is difficult to use database objects declared in a module from within a form.
Show Answer
Hide Answer
61. Suppose from form1 to form2 object property settings will arise to ?
Answer: Invalid procedure call or argument (Run time error 5)
Show Answer
Hide Answer
62. What is the return type of Instr and Strcmp?
Answer: Instr integer (Numeric position)
Strcmp - integer ( if both the string are equal they result = 0)
Strcmp (Str1, Str2, Comparetype)
Comparing mode = 0 Binary Comparing
1 Textual Comparing
Show Answer
Hide Answer
63. What is Implicit?
Answer: Instance of specific copy of a class with its own settings for the properties defined in that class.
Note: The implicitly defined variable is never equal to nothing.
Show Answer
Hide Answer
64. What is Inprocess and Out of Process?
Answer: Inprocess It will run with in the memory. ( Local Machine). Out of Process It will run out of the memory Normally in the server side.
Show Answer
Hide Answer
65. Where will we give the option explicit keyword and for what?
Answer: In the general declarations section. To trap undeclared variables.
Show Answer
Hide Answer
66. How can we call Stored procedure of Back End in RDO and ADO ?
Answer: In RDO We can call using RDO Query Objects.
In ADO We can call using Command Objects.
Show Answer
Hide Answer
68. How to check the condition in Msgbox?
Answer: If(Msgbox("Do you want to delete this Record",VbYesNo)=VbYes)Then End if
Show Answer
Hide Answer
69. What is control array and how many we can have it with in the form?
Answer: Group of control share the same name. Max 32, 767.
Show Answer
Hide Answer
70. What is diff between the Generic Variable and Specific Variable?
Answer: Generic Variable:
Create Object Ex:-Ole-Automation . No need refer the object library.
Specific Variable:
Binding Procedure Early and Late Binding ( Can be Remove from the Memory).
Show Answer
Hide Answer
71. What is the diff. Between function and sub procedures?
Answer: Function will return value but a sub procedure wont return values
Show Answer
Hide Answer
72. What is the max size allowed for Extension in Visual Basic?
Answer: Frm, bas, cls, res, vbx, ocx, frx, vbp, exe
Show Answer
Hide Answer
74. With in the form we want to check all the text box control are typed or not? How?
Answer: For each currentcontrol in controls
if typeof currentcontrol is TextBox then
end if
next
Show Answer
Hide Answer
76. How to trap Data Base Error?
Answer: Dim x as RDOError
X(0).Des
X(1).Number
Setting the Cursors.
Default Cursor 0
ODBC Cursor (Client side) 1
ServerSide Cursors (More Network traffic) - 2
Show Answer
Hide Answer
77. How to declare Dll Procedure?
Answer: Declare function "" lib ""
Alias "" (Arg, ..) as Return type.
Show Answer
Hide Answer
78. Referential Integrity (Take care By jet database Engine). Cascade Delete, Cascade Update is done setting property of Attributes.?
Answer: DbRelationDeleteCascade, DbRelationUpdateCascade.
Show Answer
Hide Answer
79. How to increase the Date corresponding with month,date,year?
Answer: DateSerial(year(Now),Month(Now)+1,1)
Hour, min, sec, month, year, DateSerial, dateadd, datediff, weekday, datevalue, timeserial,timevalue.
Show Answer
Hide Answer
81. What is difference between datagrid and flexgrid?
Answer: Datagrid Editable. Flexigrid Non-Editable. (Generally used for Read only purpose.)
Show Answer
Hide Answer
83. To connect the Data Control with Back end What are all the properties to be set?
Answer: Data source Name, Record Source Name
Show Answer
Hide Answer
84. What are the Technologies for Accessing Database from Visual Basic?set?
Answer: DAO, Data Control, RDO, ODBCDIRECT, ADO, ODBC API , 0040.
Show Answer
Hide Answer
85. What is the diff between the Create Object and Get object?
Answer: Create Object - To create an instance of an object.
Get Object To get the reference to an existing object.
Show Answer
Hide Answer
86. What is Mask Edit and why it is used?
Answer: Control. Restricted data input as well as formatted data output.
Show Answer
Hide Answer
87. What is RdExecDirect?
Answer: Bypasses the Creation of a stored procedure to execute the query. Does not apply to Oracle.
Show Answer
Hide Answer
88. Different type of Passing Value?
Answer: By value, By ref, Optional, Param Array. Note:- Optional keyword cannot be used while declaring arguments for a function using param array.
Show Answer
Hide Answer
89. What are types of binding?
Answer: 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
Show Answer
Hide Answer
90. What is Dataware Control?
Answer: Any control bound to Data Control.
Ex:- Textbox, Check Box, Picture Box, Image Control, Label, List box, Combo Box, DB Combo,
Show Answer
Hide Answer
91. What methods are used for DBGrid in unbound mode?
Answer: AddData, EditData, Readdata, WriteData.
Show Answer
Hide Answer
92. What is ADO? What are its objects ?
Answer: 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.
Show Answer
Hide Answer
94. Record set types and Number available in VB?
Answer: 3.
1- Dynaset, 0 Table, 2 Snap Shot.
Show Answer
Hide Answer
100. Calling Stored Procedures in VB?
Answer: 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(?
Show Answer
Hide Answer
101. DSN Less Connection?
Answer: "Server=Oracle; Driver={Microsoft ODBC for Oracle};"
Show Answer
Hide Answer