ITPEC FE Morning April 2019 Question 28
In a client/server system, which of the following is the mechanism that reduces the network load between the client and server by placing the frequently used commands on the DBMS on the server in advance?
Explanation
Stored procedure — frequently used SQL is kept on the DBMS server, so the client sends one call instead of many statements.
Without it, the client sends each SQL statement over the network and receives each intermediate result back. With a stored procedure, the sequence of statements is registered in the DBMS in advance and compiled there; the client calls it by name with parameters, the server runs every statement locally, and only the final result travels back. Fewer round trips mean less network load.
Answer (c)
Why not others:
- •(a) Group commitment — writes the log records of several transactions to disk in one batch at commit, cutting disk writes, not network traffic
- •(b) Multithreading of server processes — lets the server handle many requests in parallel; the same statements still cross the network
- •(d) Two-phase commitment — coordinates one commit across several databases in a distributed transaction; it adds messages rather than removing them
Key rule: To cut client/server traffic, move the processing to where the data is: one request goes out and one result comes back.
Databases · AI-written, may contain errors
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official FE past-paper collection or Report an issue.