• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Visual Basic 6 Interview Questions Answers

Question - 81 : - Name the four different cursor types in ADO and describe them briefly.

Answer - 81 : - 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.

Question - 82 : - What is the diff between the Create Object and Get object?

Answer - 82 : - Create Object - To create an instance of an object. Get Object To get the reference to an existing object.

Question - 83 : - Different type of Passing Value?

Answer - 83 : - By value, By ref, Optional, Param Array. Note:- Optional keyword cannot be used while declaring arguments for a function using param array.

Question - 84 : - What are types of binding?

Answer - 84 : - 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

Question - 85 : - Can us able to set Instancing properties like Singleuse, GlobalSingleuse to ActiveXDll?

Answer - 85 : - No.

Question - 86 : - What is DBFailError?

Answer - 86 : - Rolls Back updates if any errors Occurs.

Question - 87 : - Name some date function?

Answer - 87 : - Dateadd(), Datediff(), Datepart(), Cdate()

Question - 88 : - Under the ADO Command Object, what collection is responsible for input to stored procedures?

Answer - 88 : - The Parameters collection.

Question - 89 : - What is Mixed Cursors?

Answer - 89 : - Static + Keyset

Question - 90 : - What are the ADO objects?

Answer - 90 : - 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

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners