CTFL-PT practice question 4 of 10

Which of the following protocols would allow a test script to interact with a database management system directly?

Full set: 40 questions
Answer options
A: JDBC Correct answer
B: SOAP
C: HTTPS
D: IMAP
Correct Answer:
A. JDBC
Explanation

JDBC (Java Database Connectivity) is an Application Programming Interface (API) for the Java programming language that defines how a client, such as a test script, can access a database. It provides a standard set of classes and interfaces for connecting to a database, creating and executing SQL statements, and processing the results. This allows a test script to directly manipulate the database for purposes like setting up preconditions (e.g., inserting test data) or verifying outcomes (e.g., checking if data was correctly written or updated), which is a common practice in integration and system testing.

Why Incorrect

B. SOAP: SOAP (Simple Object Access Protocol) is a messaging protocol for web services. A test script would interact with a service layer, not the database directly.
C. HTTPS: HTTPS is a secure transport protocol for web communication. It is used to access web applications or APIs, which then interact with the database, but it is not for direct database access.
D. IMAP: IMAP (Internet Message Access Protocol) is a standard protocol used by email clients to retrieve email messages from a mail server and is unrelated to database interaction.

References

1. Oracle Corporation. (2022). JDBC Basics - The Java™ Tutorials. Oracle Help Center. Retrieved from https://docs.oracle.com/javase/tutorial/jdbc/basics/index.html. This official documentation states, "JDBC is an API that lets you access virtually any tabular data source from the Java programming language." (See "What Is the JDBC API?" section).

2. W3C. (2007). SOAP Version 1.2 Part 1: Messaging Framework (Second Edition). W3C Recommendation 27 April 2007. Retrieved from https://www.w3.org/TR/soap12-part1/. Section 1, "Introduction," defines SOAP as a protocol for exchanging structured information in the implementation of web services.

3. Rescorla, E. (2000). HTTP Over TLS. IETF RFC 2818. Retrieved from https://datatracker.ietf.org/doc/html/rfc2818. Section 1, "Introduction," describes this as a mechanism to layer HTTP over a secure connection, not as a database interaction protocol.

4. Crispin, M. (2003). INTERNET MESSAGE ACCESS PROTOCOL - VERSION 4rev1. IETF RFC 3501. Retrieved from https://datatracker.ietf.org/doc/html/rfc3501. The abstract clearly defines IMAP as a protocol for accessing electronic mail messages on a server.

Scroll to Top