Author Question: Define and briefly describe the function of ODBC. What will be an ideal ... (Read 128 times)

debasdf · **on:** Jul 7, 2018

Define and briefly describe the function of ODBC.

What will be an ideal response?

Question 2

Microsoft Access:

A) supports standard SQL view statements.
B) only supports SQL view statements as QBE constructions.
C) can store a view equivalent Access query.
D) can store a view equivalent Access query but does not provide a means to use it.
E) cannot store any database object that is equivalent to an SQL view.

Dinolord · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

ODBC stands for Open Database Connectivity. It is used to solve the problem caused by each DBMS having its own proprietary application program interface (API). OBDC was created to be a bridge between program code and the APIs. A programmer can write code using ODBC standard statements, and an ODBC driver translates these statements into a form that the DBMS API can understand. Similarly, results sent though the API back to OBDC are translated into standard ODBC forms. This allows application programmers to write to OBDC as a common interface rather than having to learn many APIs.

Answer to Question 2

C