Visual Basic Interview Questions and Answers
A type of object-oriented programming language and environment developed by Microsoft for the Windows operating system. Visual Basic allows programmers to create applications quickly by writing code to accompany onscreen objects such as buttons and windows.
Visual Basic Interviews are getting tough these days as the technology grows faster. To get through the Visual Basic interview one needs to update him/herself in a regular manner. Having said that, just before the interview, it is very important to have a quick glance of the reputed Visual Basic questions and answers to make yourself comfortable during the interview process. This is where DoAnswers.com helps you in renewing yourself on Visual Basic and various other technologies interview preparation.
1. 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.
2. 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. What are the ADO objects? Expl
Under the ADO Command Object, what collection is responsible for input to stored procedures? Answer: The Parameters collection.
3. How do you register a component?
Compiling the component, running REGSVR32 MyDLL.dll
4. 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
5. 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.
6. 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.
7. Question:What does Option Explicit refer to?
All variables must be declared before use. Their type is not required.
8. What are some benefits of using MTS?
Database Pooling, Transactional operations, Deployment, Security, Remote Execution.
9. 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
10. 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.
-
Databases Questions and Answers
- DB2 Interview Questions and Answers
- IMS Interview Questions and Answers
- MYSQL Interview Questions and Answers
- Oracle Interview Questions and Answers
- PL/SQL Interview Questions And Answers
- Quel Interview Questions and Answers
- SQL Interview Questions and Answers
-
.NET Interview Questions and Answers
- ASP Interview Questions and Answers
- C# Interview Questions and Answers
- Visual Basic Interview Questions and Answers
-
J2EE Interview Questions and Answers
- Enterprise Java Beans (EJB) Interview Questions And Answers
- Hibernate Interview Questions And Answers
- Jave Messaging Service (JMS) Interview Questions And Answers
- Jave Server Faces (JSF) Interview Questions And Answers
- Java Server Pages (JSP) Interview Questions And Answers
- Servlets Interview Questions And Answers
- Spring Framework Interview Questions And Answers
- Struts Framework Interview Questions And Answers
-
JAVA Interview Questions and Answers
- Core Java Interview Questions and Answers
- Java Platform, Micro Edition (Java ME) Interview Questions And Answers
- JAVA GUI Interview Questions and Answers
- Java Performance Tuning Interview Questions And Answers
- JUnit Interview Questions And Answers
- Remote Method Invocation (RMI) Interview Questions And Answers
- Unified Modeling Language (UML) Interview Questions And Answers
-
Java Application Server Interview Questions And Answers
- Tomcat Application Server Interview Questions And Answers
- WebLogic Application Server Interview Questions And Answers
-
Mainframe Interview Questions and Answers
- CICS Interview Questions and Answers
- COBOL Interview Questions and Answers
- IMS Interview Questions and Answers
- JCL Interview Questions and Answers
- REXX Interview Questions and Answers
- TELON Interview Questions and Answers
- VSAM Interview Questions and Answers
-
Object Oriented Language Questions and Answers
- C Interview Questions and Answers
- C++ Interview Questions and Answers
- Eiffel Interview Questions and Answers
- J2EE Interview Questions and Answers
- JAVA Interview Questions and Answers
- Sather Interview Questions and Answers
- Small talk Interview Questions and Answers
-
Operation Systems Interview Questions and Answers
- MS DOS Interview Questions and Answers
- Unix OS Interview Questions and Answers
- Windows Interview Questions and Answers
-
Scripting languages Interview Questions and Answers
- Java Script Interview Questions and Answers
- Practical Extraction and Reporting Language Interview Questions and Answers
- PHP Interview Questions and Answers
- VBScript Interview Questions and Answers
-
UserInterfaces Questions and Answers
- Foxit Interview Questions and Answers
- Glade Interview Questions and Answers
- Tweak Interview Questions and Answers
-
WEB Technologies Questions and Answers
- AJAX Interview Questions and Answers
- HTML Interview Questions and Answers
- WML Interview Questions and Answers
- XML Interview Questions and Answers
-
Interview Tips And Some Common Questions
- Behavioral Interview Questions And Answers