VBA (Visual Basic for Applications) Question:

Download Job Interview Questions and Answers PDF

Explain What are the ADO objects?

VBA Interview Question
VBA Interview Question

Answers:

Answer #1
The ADO objects are:

Command
Connection
Error
Field
Parameter
Property
Record
RecordSet
Stream

Connection: Used to make a connection between your app and an external data source, i.e., 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.

Answer #2
Super 1

Answer #3
It's a bad question. The Ado object holds the properties that are listed. When you are instantiating an ADO object, you are creating the parent object which holds each one of those entities in the list.

Download VBA Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the difference between Msgbox Statement and MsgboxQ function?What is function of delete operator?