VBA Interview Questions

Sep 19 2005
04:47 PM

3022
Views

2
Ans

What are the ADO objects? Explain them.

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Dharmendra Dixit

Sep 16th, 2006

Hi all, There are 3 main objects od ADO(1) Connection - Used to make connection with Database(2) command - with this we can execyte command like(select* from)(3) Recordset - The inmemory Representation of records in ADO is known as RecordSet Thanks & Regards Dharmendra K Dixit Jr. Software Engg

Venky

Jan 18th, 2006

The ADO objects are: ? Command ? Connection ? Error ? Field ? Parameter ? Property ? Record ? RecordSet ? Stream

Answer Question Select Best Answer
Sep 19 2005
04:47 PM

2663
Views

2
Ans

VB and Object Oriented Programming

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Dharmendra Dixit

Sep 16th, 2006

Yes VB 6.0 Supports OOPS, Because VB6.0 is an Object Based Progarmming Language, and it also known as 'Event Driven Programming'it supports Polymorphism - Yes Encapsulation - Yes Inheritance - Partially support (Not full) Thanks & Regards Dharmendra K Dixit

siva prasad

Feb 5th, 2006

VB do supports oops. Polymorphism - Yes , Encapsulation -Yes, Inheritance - NO

Answer Question Select Best Answer
Sep 19 2005
04:44 PM

2319
Views

1
Ans

Kind of components can be used as DCOM servers

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

balaji

Oct 5th, 2006

Hai,DataBase Components can be used as DCOM Servers...

Answer Question Select Best Answer
Sep 19 2005
04:38 PM

2140
Views

1
Ans

How does a DCOM component know where to instantiate itself?

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

balaji

Oct 5th, 2006

Hai,When Client App requests some COM component in different machine server creates proxy object on client through which client app access the server component.

Answer Question Select Best Answer
Feb 12 2006
04:24 PM

2476
Views

2
Ans

How can we upload to sql databse images using visual basic 6.0?

eed_nnad
Profile Answers by eed_nnad Questions by eed_nnad

VBA Interview Questions

sarva dev pandey

Oct 5th, 2006

How can we upload to sql databse images using visual basic ?

Diju

Mar 3rd, 2006

Http://www.codeproject.com/cs/database/ImageSaveInDataBase.asp

Answer Question Select Best Answer
May 20 2006
02:11 PM

26951
Views

1
Ans

1) You are creating a client application that calls ActiveX DLLs. Which of the following properties of the Err object provides the name of a component that sends an error back to the client application? a. Number b. Description c. CompName d. Component e. Source f. Text g. Desc h. None of the above2) If the Cancel Error Property of the CommonDialog Box is set to true then which of the following statement is true: a. A runtime error can result if the user clicks the cancel button b. A compile time error occurs c. The program executes without any error d. You need to carry out conditional compilation e. None of the above3) What is the extension of the Visual Basic project file that stores the design of a user control. a. .ctx b. .ctl c. .ctrd. .ocxe. .vbp f. .dllg. .uclh. .utl 4) A __________ control defaults to displaying the files in the current directory: a. File List Box b. Dir List Box c. Drive List Boxd. Combo Boxe. Picture Boxf. List Boxg. Combo Boxh. DataGrid5) To destroy an object and free the memory space occupied by it, the keyword used is:a. Delete b. Kill c. Nothing d. New e. Calloc f. New g. Conserve h. Free6) Which event of a text box would you use for validating the data entered by the user? a. Validate b. Validation c. Check d. Audit e. GotFocus f. Checkdata g. ValidateDate7) Which of the following statements forces inline error handling? a. On Error GoTo linelabel b. On Error GoTo Inline c. On Error Stop d. On Error Resume Next e. On Error GoTo 0 f. On Error Resume g. None of the above8) The _______ method resets the contents of bound controls to their original values when the user clicks on the cancel button. a. UpdateControls b. PaintPicture c. Refresh d. Resizee. Resyncf. Restoreg. Cancelh. Update9) To deactivate the Form UnLoad event, you make the following change in the function definiton: Private Sub Query_Unload(Cancel as Integer,UnloadMode as Integer)To prevent the Form from closing, you will set the: a. Cancel parameter to a non-zero valueb. Cancel parameter to 0c. UnloadMode parameter to a non-zero valued. UnloadMode parameter to a zero valuee. UnloadMode parameter to 1f. Cancel parameter to 110) How many root nodes can a TreeView control have? a. 1 b. 2 c. 3 d. 4 e. 5 f. 10 g. Upto 50 h. No limit 11) A project group is a Project which: a. Consists of several Programs b. Consists of several Applications c. Consists of Various Forms And Code Modules d. Consists of several Projects12) Procedures declared in a _____ are local whereas procedures declared in a ______ are available to the whole application. a. Form window, standard or code moduleb. Project window, view code windowc. Class module, code module13) How can you keep the user from exiting a form by clicking the Close button? a. Place code in the Terminate event b. Place code in the Unload event c. Place code in the QueryUnload event d. This can only be done by using the Windows API e. Place code in the Load event f. Place code in the Terminate event g. Place code in the Deactivate event h. None of the above14) In order to provide a transparent background to the Form, you must change the _________ property to _______. a. BackStyle, Opaque b. BackColor, White c. BackStyle, Transparent d. BackColor, Parent Window's Color e. ZOrder, 0 f. BackColor, Transparent15) The _______ property enables Visual Basic to draw complete images in memory before displaying them on the Screen. a. AutoRedraw = True b. AutoRedraw = False c. Refresh d. PaintPicture16) You want to display the code and the description of an error. What would be the correct syntax? a. Msgbox err.no & err.text b. Msgbox err.number & err.text c. Msgbox error.number & error.text d. Msgbox error.number & error.description e. Msgbox err.number & err.description f. Msgbox err.num & err.description g. Msgbox err.num & err.text h. None of the above17) What is the purpose of the Image List Control? a. To display images to the userb. To help in creating a ToolBarc. To allow the editing of icons d. To provide a repository for images used by other controls e. To provide images to the listbox control f. To provide images for the splash screen g. To provide icons for error messages18) Which method would you use to get a free or unused File identifier while opening any file: a. FreeFile b. GetFileNum c. GetFiled. GetBytese. NextFilef. Fileg. GetNextFileh. None of the above19) Which property procedure is used to retrieve the value of a property? a. Retrieveb. Getc. GetPropertyd. Valuee. RetrieveValue 20) Which of the following can be shown to the user using the Common Dialog control in VB? a. Common messages passed to Windowsb. Open dialog boxc. Windows explorerd. Input boxe. Message boxf. Error messagesg. Helph. None of the above21) Which event is triggered when the user moves to another open form? a. Unloadb. QueryUnloadc. Deactivated. Terminatee. Load f. Initializeg. Repainth. Resize22) Which event of an ActiveX control data provider runs every time a bound control extracts data through the provider? a. GetDataMember b. GetDataField c. GetDataProperty d. GetDataRow e. GetData f. GetFields g. GetRows h. RetrieveData23) Which of the following are not properties of Command Button:a. Captionb. Visiblec. Multi-Lined. Fonte. Namef. Boldg. Tagh. Enabled24) You are creating an ActiveX component that raises user-defined errors. Which of the following statements correctly raises an error to the client with error number 20000? a. Err.Raise vbObjectError + 20000b. Err.Number = 20000c. Err.Raise 20000d. Err.Raise vbObjectError,20000e. Err.Number 20000 f. Error.Raise vbObjectError + 20000g. Error.Number 20000 h. Error.Raise 2000025) Which events enable you to determine which key was pressed by the user? a. Click and KeyPress b. Click, KeyUp and KeyDown c. KeyUp and KeyDown d. KeyPress, KeyUp and KeyDown e. Click, KeyPress, KeyUp and KeyDown 26) In order to access a file in Non-textual format, you have to open file in: a. Ascii Format b. Binary Format c. Input Mode d. Output mode e. Append mode f. Read Mode27) Visual Basic displays information depending upon the current value of two properties of the form, called:a. CurrentX and CurrentYb. ScaleLeft and ScaleTopc. ScaleHeight and ScaleTopd. x and ye. TopX and TopYf. LeftX and LeftY28) Which of the following procedure types will execute when you assign a value to a property of an object? a. Property Getb. Property Assignc. Property Letd. Property Sete. Public Sub 29) In order to overlap the controls (say a command button) during design time, we use the 'Send To Back' or 'Bring To Front' option from the Edit menu. To change it dynamically (i.e. during program execution) we need to change:a. Background color propertyb. Caption propertyc. ZOrder propertyd. AutoRedraw propertye. SendtoBack propertyf. BringtoFront propertyg. Hide propertyh. Show property30) Name the only property supported by a collection? a. Nameb. Indexc. Countd. Typee. Value f. Addg. Removeh. None of the above31) Which of the following situations would not cause the Initialize event of an ActiveX control to occur? a. When a control is placed on a form at design timeb. When a form designer containing a control is closedc. When a form is rund. When a compiled application containing a control executese. When an application terminates and re-enters design-time for the host application 32) Which event occurs only once in the entire life cycle of an ActiveX control? a. Initializeb. Resizec. Terminated. WritePropertiese. InitProperties f. Activate g. None of the above34) You are creating an ActiveX component that raises user-defined errors. What is the valid range of error numbers that you can use for user-defined errors? a. 1-1000 b. 0-255 c. 1-65535 d. 0-1000 e. 513-65535 f. 1000-2000 g. 10000-20000 h. None of the above35) Which property of the ProgressBar determines how much of the bar is filled? a. Minb. Maxc. Valued. CurrentVale. FillValue f. Fillg. BarComplete36) The ______ function can be used to run any .com, .exe, .bat or .pif file from a Visual Basic program. a. Shell b. Substr c. SetAttr d. CStr e. Exec f. Perform g. Do h. None of the above 37) One can convert a Visual Basic Application into ActiveX Document using: a. Visual Database Manager b. Application Wizard c. ActiveX Document Migration Wizard d. Package and Deployment Wizard38) The caption and the name properties of the command button:a. Are one and the sameb. Can be different at timesc. Are actually not properties39) You try to initialize a new Object variable with the following line but receive an error. What could be the possible cause? Set MyVar = New Classnamea. You do not need to use the Set command hereb. You do not have the permission to access the classc. MyVar has not been declaredd. You do not need to use the New keyword heree. None of the above40) Which of the following will perform a direct execution of a Command object? a. The Execute methodb. The Prepare methodc. The ExecDirect methodd. The Open methode. The Exec method f. The ExecProcedure methodg. None of the above41) The vbCritical symbol displays: a. A warning query iconb. A critical message iconc. A warning message icond. An exclamation icone. None of the above42) What does the forms collection contain? a. A list of all forms in a project b. A list of all hidden forms c. A list of all currently loaded forms d. A list of all visible forms e. All the child forms of an MDI application43) Which method of the Recordset object should you use to navigate multiple recordsets returned by a stored procedure? a. NewRecordset b. NavigateRecordset c. OpenNextRecordset d. NextRecordset e. SkipRecordset f. PreviousRecordset g. JumpRecordset h. GoTORecordset44) Which of the following cannot be included in the Open method of the recordset? a. Cursor Type b. User Name c. Active Connection d. CursorLocation e. LockType f. Source45) The settings for the Color properties in Visual Basic are indicated by: a. Decimal Coding b. Octal Coding c. Hexadecimal Coding d. Binary Coding46) What you must do before you make calls to an ActiveX DLL project in the same Project Group? a. Compile the DLL b. Check the DLL off in your project's Reference List c. Make sure the DLL is the Startup Project d. Ensure that a Standard Exe form is included and is made the Startup Form.47) The _______ property changes the tab order at runtime: a. Tab stop b. Tab key c. Tab order d. Tab index48) What do CurrentX and CurrentY return? a. Current X and Y co-ordinates of mousepointer b. Current X and Y co-ordinates of cursor c. A String of X & Y d. Current x and y co-ordinates of the control49) The Kill command in Visual Basic is used for:a. Stopping the current process b. Deleting files c. Terminating the application d. Stopping the current thread e. Debugging the application f. Error handling g. None of the above50) If one needs to use an ampersand(&) in a Label but does not want it to be an Access Key, the _______ property of the label must be set to False. a. Caption b. ClipControls c. UseMnemonic d. LinkMode e. Locked f. Label g. ZOrder h. Visible51) Which of the following is the only drag related event? a. DragEnter b. DragLeave c. DragStart d. DragStop e. DragDrop f. BeginDrag g. EndDrag52) Which property of the form changes the form's title? a. Name b. Heading c. Title d. Caption e. Logo 53) Labels do not respond to _____ and ______ events. a. Got_Focus , Lost_Focus b. Click , DblClick c. Dragdrop , OLECompleteDrag d. Change, Link Error54) Which of the following statements is capable of abandoning a series of modifications made to a recordset locked with a BatchOptimistic lock? a. CancelUpdate b. CancelBatch c. CancelBatchUpdate d. AbandonBatch e. AbandonBatchUpdate f. Rollbackupdate g. Rollbackbatch h. None of the above55) Which three methods does the collection object support? a. Let, Get, Set b. Load, Unload, Count c. Add, Remove, Item d. Add, Delete, Index e. Add, Remove, Sort f. Add, Remove, Count g. Add, Delete, Count h. Add, Set, Count56) Which line of code listed here can be used to create a string of fixed length: a. Dim strFirstName as String b. strFirstName * 255 c. strFirstName = 255 d. Dim strFirstName as String(255) e. None of the above57) Consider the following program code:(i) Dim FileName as StringOpen FileName For Input As #FreeFile(ii) Dim FileName as StringFileNum = FreeFileOpen FileName For Input As #FileNum a. Both (i) and (ii) are correct b. Only (i) is correct c. Only (ii) is correct d. (i) contains a logical error e. (ii) contains an error f. Both (i) and (ii) contain errors58) Which property of the Err object returns the numeric value associated with the most recent runtime error? a. Description b. No c. Number d. Source e. Errorcode f. Num g. Code59 ) In Visual Basic, which method can you use to send key strokes to other Window applications? a. AppActivate b. SendKeys c. Copying the contents from the ClipBoard & pasting d. Manually typing in the other application's Window60) The ______ property is used to show Tool Tips or Help Balloons when the mouse rests on the object:a. ToolTipText b. Tag c. Dragmode d. ShowTips e. Help f. Tip g. ShowHelp h. Tab61) What is the sequence in which the following events are triggered when a form is loaded? a. Initialize, Load, Resize and Paint b. Initialize, Load, Paint and Resize c. Load, Initialize, Resize and Paint d. Load, Initialize, Paint and Resize e. Initialize, Resize, Paint and Load f. Load, Paint,Initialize and Resize g. Initialize, Paint, Load and Resize h. Paint, Resize, Initialize and Load62) Which parameter of the WriteProperty method can be omitted but should be included to increase the efficiency of the control? a. Name b. Value c. Caption d. PropBag e. DefaultValue f. Title g. Tag h. None of the above63) Message Boxes can hold a maximum of _______ characters. a. 256 b. 512 c. 1024 d. 2046 e. 4092 f. 5000 g. 10000 h. No limit64) Which parameter of the Execute method of the Connection object returns the number of records that the operation affected? a. RecordsAffected b. RowsAffected c. RecordsUpdated d. RowsOperated e. RecordsOperated 65) Which of the following is not an element of the ADO model? a. Database b. Error c. Connection d. Parameter e. Recordset f. Field g. Driver66) What data type is the HelpContextID? a. String b. Integer c. Single d. Double e. Long f. Char g. Float67) Variables that allow sharing of values across event procedures are called: a. Form level variable b. Object variable c. Module level variable68) Which property of the ListView control determines which field a sort is based on? a. Sorted b. SortKey c. SortOrder d. SortField e. Sort f. Key g. ListKey h. None of the above69) Consider the following subprogram:Sub ChangeText(ByVal X as String,Y as String)Y = XEnd SubIf you are calling it using the following code:Call ChangeText(Form1.Caption,Y$)a. The Caption of Form1 will change to the value contained in Y$ b. The Caption of Form1 will not change c. The Caption changes at random intervals after the function call d. The code is incorrect70) Visual Basic fires the _______ event everytime a part of the form is newly exposed. a. Load b. Activate c. Paint d. Show e. Initialize71) Which of the following ADO recordset types provides the greatest degree of concurrency? a. Static b. Forward-only c. Dynamic d. Keyset e. Read only f. Keyset and Dynamic72) Which of the following is the only valid Resume statement in an error handler? a. Resume prior b. Resume previous c. Resume later d. Resume next e. Resume before f. Resume to g. Resume statement h. Resume application

shailesh

VBA Interview Questions

Please give me the answer for this . who is the master.

ravi

Oct 13th, 2006

1) source

Answer Question Select Best Answer
Sep 19 2005
04:48 PM

3182
Views

3
Ans

What does the Implements statement do?

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Sanjay Kumar Dalai

Nov 21st, 2006

Hi, This Implements Statemets generally used for the purpose of Inheritance. If you want to impelments properties,method & events of super class&...

suhani02
Profile Answers by suhani02 Questions by suhani02

Sep 12th, 2006

Implements statement Specifies one or more interfaces, or interface members, that must be implemented in the class or structure definition in which it appears.

Answer Question Select Best Answer
Sep 19 2005
04:37 PM

2558
Views

2
Ans

Describe: In of Process vs. Out of Process component. Which is faster?

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Sanjay Kumar Dalai

Nov 21st, 2006

Dear All,In of process component running in same address space but out of?Process component running in different address spaces. Out of Process component create separate thread & run in that thread....

Answer Question Select Best Answer
Sep 19 2005
04:33 PM

2755
Views

2
Ans

Advantages of disconnected record sets

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Sanjay Kumar Dalai

Nov 23rd, 2006

Dear All,disconnected record gives more advantages in Database connection free.when user open a recordset using table/vew ,it will lock the table/view as user not free its.As result other user can't d...

Answer Question Select Best Answer
Sep 19 2005
04:37 PM

4745
Views

2
Ans

Define the scope of Public, Private, Friend procedures?

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Sanjay Kumar Dalai

Dec 5th, 2006

Dear All,when we declare private procedure that procedure can be access with in the current module.It can't be access out side the module.private key word use for data hiding purpose.In case of F...

Answer Question Select Best Answer
Sep 19 2005
04:45 PM

5991
Views

3
Ans

Name the four different cursor and locking types in ADO and describe them briefly

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Sanjay Kumar Dalai

Dec 5th, 2006

Dear All,Four type of Cursor 1.Satic 2.KeySet 3.Dynamic 4. Forwar Only .Static Cursor :we can't delete,update and Insert data.It can't display any modification of data by other users.This one faster f...

v_k_paramesh
Profile Answers by v_k_paramesh Questions by v_k_paramesh

Nov 18th, 2005

Cursor types:1. Forwardonly, 2. Static, 3. Keyset 4. DyanmicLock types : 1. lockpessimistic, 2. lockoptimistic,3. lockbatchoptimistic 4. lockreadonly

Answer Question Select Best Answer
Nov 22 2006
06:50 AM

11184
Views

2
Ans

Why we use DoEvents in VB6.0?

sanjay kumar Dalai

VBA Interview Questions

Ganapathy.C.M

Dec 19th, 2006

In the bad old days (before Win95), Windows could only do one thing at a time. This meant that events like mouse clicks and other user input could only be serviced in order, like everything else, even...

Answer Question Select Best Answer
Dec 29 2006
10:01 AM

6256
Views

2
Ans

What is ADO, OLEDB & ODBC?

sunil kumar

VBA Interview Questions

spandia
Profile Answers by spandia Questions by spandia

Feb 15th, 2007

ODBC : Open Database Connectivity(ODBC) is a windows technology that lets a database client application connect to a external database.OLEDB : Low level programming interface designed ...

Answer Question Select Best Answer
Sep 19 2005
04:33 PM

2567
Views

2
Ans

Benefits of using MTS

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

ravindra

Apr 1st, 2007

Object pooling....

Answer Question Select Best Answer
Sep 19 2005
04:36 PM

2619
Views

2
Ans

Default property of datacontrol

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Subashini.Ramasamy
Profile Answers by Subashini.Ramasamy Questions by Subashini.Ramasamy

Apr 2nd, 2007

Connect Property

Answer Question Select Best Answer
Sep 19 2005
04:35 PM

2571
Views

4
Ans

Controls which do not have events

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Subashini

Apr 2nd, 2007

Shape and Line Controls

Nagesh

Aug 24th, 2006

Line Control

Answer Question Select Best Answer
Sep 20 2005
11:02 AM

2963
Views

3
Ans

Thanks, Liglin">
Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is on A1 and if the Enter key is pressed, then the focus should go to B2 and a MsgBox should appear. I think this can be done with key events, something like OnKeyDown, but how do I tell it I want the event only be triggered by the Enter key? Thanks, Liglin

Liglin

VBA Interview Questions

sc

Jun 8th, 2007

Trap Enter with ASC code 13 not 32 (which is ASCII code of space)

samitbasu
Profile Answers by samitbasu Questions by samitbasu

Feb 16th, 2006

Use KeyAscii and trap enter(32).

Answer Question Select Best Answer
Sep 19 2005
04:37 PM

2831
Views

2
Ans

Describe Database Connection pooling relative to MTS

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

sathish

Jul 7th, 2007

This enables MTS to reuse database connections.? Database connections are sent to "sleep" mode as against normal constructions and destructions.? This can be revoked upon request.

Answer Question Select Best Answer
Sep 19 2005
04:35 PM

3150
Views

3
Ans

Constructors and distructors

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

Amar

Oct 9th, 2007

Constructors have same name as class has, constructor's need not any call through objects, they are called automatically when an instance of class is created.Destructors are used to make the memory free used by constructor variable, it do it's job just defining a destructor at the end of pro.?

Sandeep

Oct 17th, 2005

When we initialize the form at that time if we want to set any variable's value then we can set it by defining in constructor. constructor 's name always same as class name.and destructor is used to recover memory occupied by any variable defining in constructor.

Answer Question Select Best Answer
Sep 19 2005
04:32 PM

5230
Views

2
Ans

ActiveX and Types of ActiveX Components in VB

Beena
Profile Answers by Beena Questions by Beena

VBA Interview Questions

rajen singh

Nov 12th, 2007

ACTIVEX: ActiveX are reusable software components or simply a class by which we can call a member functions or datamembers on creating object or simply drag & drop a control to access its functionality.3 Types:ActiveX dllActiveX exeActiveX control

Answer Question Select Best Answer

Login

What are the ADO objects? Explain them.

Dharmendra Dixit

Venky

VB and Object Oriented Programming

Dharmendra Dixit

siva prasad

Kind of components can be used as DCOM servers

balaji

How does a DCOM component know where to instantiate itself?

balaji

How can we upload to sql databse images using visual basic 6.0?

sarva dev pandey

Diju

ravi

What does the Implements statement do?

Sanjay Kumar Dalai

suhani02

Describe: In of Process vs. Out of Process component. Which is faster?

Sanjay Kumar Dalai

Advantages of disconnected record sets

Sanjay Kumar Dalai

Define the scope of Public, Private, Friend procedures?

Sanjay Kumar Dalai

Name the four different cursor and locking types in ADO and describe them briefly

Sanjay Kumar Dalai

v_k_paramesh

Why we use DoEvents in VB6.0?

Ganapathy.C.M

What is ADO, OLEDB & ODBC?

spandia

Benefits of using MTS

ravindra

Default property of datacontrol

Subashini.Ramasamy

Controls which do not have events

Subashini

Nagesh

sc

samitbasu

Describe Database Connection pooling relative to MTS

sathish

Constructors and distructors

Amar

Sandeep

ActiveX and Types of ActiveX Components in VB

rajen singh

Latest News

It looks like you are using an AD Blocker!