ITPEC FE Morning April 2019 Question 28
ITPEC FE Morning April 2019 — Question 28 of 80
Stored Procedure — a precompiled set of SQL commands stored on the DBMS server.
The client calls the procedure by name instead of sending multiple SQL statements over the network → reduces network load.
Why not others:
- (a) Group commitment — optimizes transaction log writes, not network traffic
- (b) Multithreading of server processes — improves server-side concurrency, does not reduce data sent over the network
- (d) Two-phase commitment — coordinates distributed transactions across multiple nodes, unrelated to reducing network load
Key rule: "Placing frequently used commands on the server in advance" = stored procedure by definition.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
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.