ActiveX Data Objects (ADO) is an API that allows applications to access back-end database systems. It is a set of ODBC interfaces that exposes the functionality of data sources through accessible objects. Which of the following are incorrect characteristics of ADO?

i.It’s a low-level data access programming interface to an underlying data access technology (such as OLE DB).
ii. It’s a set of COM objects for accessing data sources, not just database access.
iii. It allows a developer to write programs that access data, without knowing howthe database is implemented.
iv. SQL commands are required to access a database when using ADO.

A.
i, iv

B.
i, ii

C.
i, ii, iii

D.
ii, iii

Explanation:
The following are correct characteristics of ADO:

– It’s a high-level data access programming interface to an underlying data access technology (such as OLE DB).
– It’s a set of COM objects for accessing data sources, not just database access.
– It allows a developer to write programs that access data, without knowing how the database is implemented.
– SQL commands are not required to access a database when using ADO.