Which of the following are correct characteristics of Object Linking and Embedding Databases?’

i.It’s a replacement for ODBC, extending its feature set to support a wider variety of nonrelational databases, such as object databases and spreadsheets that do not necessarily implement SQL.
ii. A set of COM-based interfaces provide applications with uniform access to datastored in diverse data sources.
iii. Because it is COM-based, OLE DB is limited to use by Microsoft Windows-based client tools.
iv. It allows different applications to access different types and sources of data.

A.
i

B.
i,ii, iii, iv

C.
i, iii

D.
i, ii, iii

Explanation:
Object Linking and Embedding Database (OLE DB) separates data into components that run as middleware on a client or server. It provides a low-level interface to link information across different databases and provides access to data no matter where it is located or how it is formatted. The following are some characteristics of OLE DB:

– It’s a replacement for ODBC, extending its feature set to support a wider variety of nonrelational databases, such as object databases and spreadsheets that do notnecessarily implement SQL.
– A set of COM-based interfaces provide applications with uniform access to data stored in diverse data sources
– Because it is COM-based, OLE DB is limited to use by Microsoft Windows-based client tools.
– It allows different applications to access different types and sources of data.