CT-PT practice question 2 of 10

Which of the following is considered a common database protocol?

Full set: 40 questions
Answer options
A: ODBC Correct answer
B: JUNIT
C: SMP
D: MMS
Correct Answer:
A. ODBC
Explanation

ODBC (Open Database Connectivity) is a widely adopted application programming interface (API) standard for accessing database management systems (DBMS). It provides a common, vendor-neutral interface that allows an application to access data from various databases without needing to be rewritten for each specific database system. By defining a standard set of functions and SQL conformance levels, it facilitates communication between applications and databases, effectively serving as a standard protocol for database interaction.

Why Incorrect

B. JUNIT: This is a unit testing framework for the Java programming language, used for writing and running repeatable tests, not for database communication.
C. SMP: This typically stands for Symmetric Multiprocessing, a computer architecture where multiple identical processors share a single main memory, not a database protocol.
D. MMS: This is the Multimedia Messaging Service, a standard for sending messages that include multimedia content over cellular networks, unrelated to database protocols.

References

1. Microsoft Corporation. (2021). ODBC Programmer's Reference: What is ODBC? Microsoft Docs. Retrieved from https://docs.microsoft.com/en-us/sql/odbc/reference/what-is-odbc

2. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. Chapter 9, Section 9.5 discusses database connectivity standards, including ODBC as a primary example of a standard API.

3. IEEE. (1995). An Introduction to ODBC. IEEE Potentials, 14(3), 38-40. doi:10.1109/45.406603. This article describes ODBC as a standard for interoperability among database applications.

Scroll to Top