Read the most frequently asked 50 top Visual Basic (VB) interview questions and answers for freshers and experienced.
Visual Basic (VB) Interview Questions and Answers PDF Experienced Freshers
1. How do you register a component?
Compiling the component, running REGSVR32 MyDLL.dll
2. 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
3. Why is it important to use source control software for source code?
Modification history.Code ownership: Multiple people can not modify the same code at the same time.
4. What two methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?
SetComplete and SetAbort.
5. What is the tool used to configure the port range and protocols for DCOM communications?
DCOMCONFIG.EXE
• StumbleUpon
• Digg
• Delicious
• Twitter
• FaceBook
• LinkedIn
6. What does Option Explicit refer to?
All variables must be declared before use. Their type is not required.
7. What are the different ways to Declare and Instantiate an object in Visual Basic 6?
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
8. Name the four different cursor types in ADO and describe them briefly.
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.
9. 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.
10. Describe Database Connection pooling (relative to MTS )?
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.
11. What are the ADO objects?
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 = ?CONNECTION STRING?conn.OpenSet Cmd.ActiveConnection = connCmd.CommandText = ?SQL STATEMENT?Set rs = Cmd.ExecuteSet rs.ActiveConnection = Nothingconn.Close
12. Under the ADO Command Object, what collection is responsible for input to stored procedures?
The Parameters collection.
13. What are some benefits of using MTS?
Database Pooling,
Transactional operations,
Deployment,
Security,
Remote Execution.
14. What is the benefit of wrapping database calls into MTS transactions?
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.
15. Describe and In Process vs. Out of Process component. Which is faster?
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, exe’s are slower then dll’s because communications between client and component must be marshalled across process boundaries. A single instance of an out of process component can service many clients.
16. 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.
17. Can We create CGI scripts in VB?
Yes we can create CGI scripts in VB
18. Dim x, y as integer. What is x and y data type?
X as variant and y as integer.
19. What is Centralization Error Handling?
Writing function and calling it when error occurs.
20. What is frx? What is frx?
When some controls like grid and third party control placed in our application then it will create frx in run time.
21. What is the Dll required for running the VB?
Vbrun300.dll
22. Why we use Treeview Control in VB?
To list the hierarchical list of the node objects. Such of files and Directories.
23. Handling Error in Calling chain.
This will call the top most error where the error is handled.
24. In project properties if we set Unattended what is it mean?
This cannot have user interface. This can be used for the COM creation.
25. What is the size of the variant data type?
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.
26. What is view Port in VB?
The area under which the container provides the view of the ActiveX Document is known as a view port.
27. What are the different types of error in VB?
Syntax Errors,
Runtime ,
Logic.
28. What is the diff between the Std and Class Module in VB?
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.
29. What is Mixed Cursors in VB?
Static + Keyset
30. Drag and Drop state numbers and functions in VB?
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.
31. What are the Style Properties of Combo Box in VB?
Simple, Dropdown list We can type and select. Dropdown Combo Only Drop Down.
32. What are the Style properties of List Box in VB?
Simple Single Select , Extended. Multiple Select.
33. What is Collection Objects in VB?
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.
34. What is the difference between Property Get, Set and Let?
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.
35. How to change the Mouse Pointer?
Screen.MousePointer = VBHourGlass/VBNormal.
36. What is Friend Variable?
Scope sharable between projects.
37. What is DBFailError?
Rolls Back updates if any errors Occurs.
38. What are the record set types?
RdOpenFowardOnly 0 (Default used only for the read only purpose)
RdOpenStatic 1
RdOpenDynamic 2
RdOpenKeySet 3 (Normally used for the live project)
39. What is the diff between RDO and ADO?
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.
40. Diff types of Lock Types?
RdConcurReadOnly 0 (Default)
RdConcurLock 1 (Pessimistic Locking)
RdConcurRowver 2 (Optimistic Lociking)
RdConcurValues 3
RdConcurBatch 4
41. What are the scopes of the class?
Public,
private,
Friend
42. Have you create Properties and Methods for your own Controls?
Properties Public variable of a Class
Method Public procedure of a class
43. Private Dim x as integer. Valid ?
Private cannot be used in front of DIM.
44. Different type of Instantiation in VB?
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.
45. What are the different types of Dialog Box in VB?
Predefined,
Custom,
User Defined.
46. What is Seek Method which type of record set is available this?
Only in DbOpenTables.
Syntax: rs.index = "empno"
rs.seek "=" , 10
If with our setting the rs.index then run time error will occur.
47. What is Zorder Method?
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.
48. Can us able to set Instancing properties like Singleuse, GlobalSingleuse to ActiveXDll?
No
49. What are properties available in Clip Board?
No Properties Available. Only the methods they are SetText,
GetText,
Setdata(),
Getformat(),
Clear.
50. What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?
Microsoft ODBC driver will support all the methods and properties of Visual Basic. Where as the Oracle not.
Visual Basic (VB) Interview Questions and Answers PDF Experienced Freshers
Compiling the component, running REGSVR32 MyDLL.dll
2. 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
3. Why is it important to use source control software for source code?
Modification history.Code ownership: Multiple people can not modify the same code at the same time.
4. What two methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?
SetComplete and SetAbort.
5. What is the tool used to configure the port range and protocols for DCOM communications?
DCOMCONFIG.EXE
• StumbleUpon
• Digg
• Delicious
6. What does Option Explicit refer to?
All variables must be declared before use. Their type is not required.
7. What are the different ways to Declare and Instantiate an object in Visual Basic 6?
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
8. Name the four different cursor types in ADO and describe them briefly.
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.
9. 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.
10. Describe Database Connection pooling (relative to MTS )?
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.
11. What are the ADO objects?
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 = ?CONNECTION STRING?conn.OpenSet Cmd.ActiveConnection = connCmd.CommandText = ?SQL STATEMENT?Set rs = Cmd.ExecuteSet rs.ActiveConnection = Nothingconn.Close
12. Under the ADO Command Object, what collection is responsible for input to stored procedures?
The Parameters collection.
13. What are some benefits of using MTS?
Database Pooling,
Transactional operations,
Deployment,
Security,
Remote Execution.
14. What is the benefit of wrapping database calls into MTS transactions?
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.
15. Describe and In Process vs. Out of Process component. Which is faster?
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, exe’s are slower then dll’s because communications between client and component must be marshalled across process boundaries. A single instance of an out of process component can service many clients.
16. 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.
17. Can We create CGI scripts in VB?
Yes we can create CGI scripts in VB
18. Dim x, y as integer. What is x and y data type?
X as variant and y as integer.
19. What is Centralization Error Handling?
Writing function and calling it when error occurs.
20. What is frx? What is frx?
When some controls like grid and third party control placed in our application then it will create frx in run time.
21. What is the Dll required for running the VB?
Vbrun300.dll
22. Why we use Treeview Control in VB?
To list the hierarchical list of the node objects. Such of files and Directories.
23. Handling Error in Calling chain.
This will call the top most error where the error is handled.
24. In project properties if we set Unattended what is it mean?
This cannot have user interface. This can be used for the COM creation.
25. What is the size of the variant data type?
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.
26. What is view Port in VB?
The area under which the container provides the view of the ActiveX Document is known as a view port.
27. What are the different types of error in VB?
Syntax Errors,
Runtime ,
Logic.
28. What is the diff between the Std and Class Module in VB?
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.
29. What is Mixed Cursors in VB?
Static + Keyset
30. Drag and Drop state numbers and functions in VB?
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.
31. What are the Style Properties of Combo Box in VB?
Simple, Dropdown list We can type and select. Dropdown Combo Only Drop Down.
32. What are the Style properties of List Box in VB?
Simple Single Select , Extended. Multiple Select.
33. What is Collection Objects in VB?
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.
34. What is the difference between Property Get, Set and Let?
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.
35. How to change the Mouse Pointer?
Screen.MousePointer = VBHourGlass/VBNormal.
36. What is Friend Variable?
Scope sharable between projects.
37. What is DBFailError?
Rolls Back updates if any errors Occurs.
38. What are the record set types?
RdOpenFowardOnly 0 (Default used only for the read only purpose)
RdOpenStatic 1
RdOpenDynamic 2
RdOpenKeySet 3 (Normally used for the live project)
39. What is the diff between RDO and ADO?
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.
40. Diff types of Lock Types?
RdConcurReadOnly 0 (Default)
RdConcurLock 1 (Pessimistic Locking)
RdConcurRowver 2 (Optimistic Lociking)
RdConcurValues 3
RdConcurBatch 4
41. What are the scopes of the class?
Public,
private,
Friend
42. Have you create Properties and Methods for your own Controls?
Properties Public variable of a Class
Method Public procedure of a class
43. Private Dim x as integer. Valid ?
Private cannot be used in front of DIM.
44. Different type of Instantiation in VB?
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.
45. What are the different types of Dialog Box in VB?
Predefined,
Custom,
User Defined.
46. What is Seek Method which type of record set is available this?
Only in DbOpenTables.
Syntax: rs.index = "empno"
rs.seek "=" , 10
If with our setting the rs.index then run time error will occur.
47. What is Zorder Method?
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.
48. Can us able to set Instancing properties like Singleuse, GlobalSingleuse to ActiveXDll?
No
49. What are properties available in Clip Board?
No Properties Available. Only the methods they are SetText,
GetText,
Setdata(),
Getformat(),
Clear.
50. What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?
Microsoft ODBC driver will support all the methods and properties of Visual Basic. Where as the Oracle not.
0 comments:
Post a Comment