Question

Client program opens a connection to the database server.

Client program submits SQL to the server
When the database access is no longer needed, the client program terminates the connection
a. Two-tier architecture
b. Three-tier architecture
c. Client-server architecture
d. Distributed database architecture

Answer 1

The scenario represents a client-server architecture, more specifically a two-tier architecture, which involves the interaction between a client program and a database on a server.

Step-by-step explanation:

The scenario described in the question where a client program opens a connection to a database server, submits SQL commands, and then terminates the connection when not needed, is indicative of a client-server architecture. This setup is predefined as a two-tier architecture, which is a type of client-server system where the user interface is housed on the client machine and the database systems are managed on the server. This model allows for direct and straightforward interaction between the database and the program.