Visual Basic 6 Interview Questions and Answers
Question - 11 : - What are the ADO objects?
Answer - 11 : - 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
Question - 12 : - Under the ADO Command Object, what collection is responsible for input to stored procedures?
Answer - 12 : - The Parameters collection.
Question - 13 : - What is view Port?
Answer - 13 : - The area under which the container provides the view of the ActiveX Document is known as a view port.
Question - 14 : - What are the different types of error?
Answer - 14 : - Syntax Errors, Runtime , Logic.
Question - 15 : - What is the diff between the Std and Class Module?
Answer - 15 : - 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.
Question - 16 : - What is Mixed Cursors?
Answer - 16 : - Static + Keyset
Question - 17 : - Drag and Drop state numbers and functions?
Answer - 17 : - 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.
Question - 18 : - What are the Style Properties of Combo Box?
Answer - 18 : - Simple, Dropdown list We can type and select. Dropdown Combo Only Drop Down.
Question - 19 : - What are the Style properties of List Box?
Answer - 19 : - Simple Single Select , Extended. Multiple Select.
Question - 20 : - What is Collection Objects?
Answer - 20 : - 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.