Part A: MCQs and True$/$False:

i$.$ The $\_\_\_\_\_\_\_\_$ processes ODBC requests and submits specific SQL statements to a given type of data source.

A$)$ driver manager

B$)$ ADO

C$)$ driver

D$)$ source converter

ii$.$ Which of the following is a function performed by the driver manager in ODBC?

A$)$ Submit SQL statements to the data source

B$)$ Determine the type of DBMS that processes a given ODBC data source

C$)$ Load the appropriate ODBC driver into memory

D$)$ Both B and C are correct

iii. The main components of the JDBC are the following:

A$)$ DriverManager, Driver, Connection, and Statement

B$)$ DriverManager, Statement, and ResultSet

C$)$ DriverManager, Driver, Connection, Statement, and ResultSet

D$)$ DriverManager, Connection, Statement, and ResultSet

iv$.$ OLE DB breaks the features and functions of a DBMS into what type of objects?

A$)$ COM

B$)$ JSP

C$)$ MTS

D$)$ ODBC

v$.$ Every DBMS product uses same application programming interface $($API$).$ True$/$False

vi$.$ ODBC works with table$-$like data sources such as relational databases and spreadsheets. True$/$False

vii. OLE DB objects are COM objects. True$/$False