Development effort assertion: Assess the claim: "Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application."
-
ADoes not apply (the claim is generally incorrect)
-
BApplies universally (always correct)
-
CApplies only when no UI is required
-
DApplies only on legacy Sybase ASE
-
EApplies only for read-only analytics
Answer
Correct Answer: Does not apply (the claim is generally incorrect)
Explanation
Introduction / Context: Stored procedures implement data-centric business logic inside the DBMS, while tools such as Visual Basic or PowerBuilder are used to build full applications, including presentation and orchestration. This question probes a blanket time-to-develop assertion that is misleading without context.
Given Data / Assumptions:
- Stored procedures handle data manipulation, validations, and set-oriented operations.
- GUI application development involves UI design, event handling, navigation, and client-side logic.
- Project scope and complexity determine effort; the technologies address different concerns.
Concept / Approach: You cannot generally say stored procedures take less time than creating an entire application. For a given data operation, a single stored procedure may be concise and performant, but building the whole application still requires significant client-side work. In many modern stacks, business logic is split between services and the DB; effort depends on distribution of responsibilities, tooling, and team skills.
Step-by-Step Solution:
Identify the scope mismatch: a stored procedure vs. an entire application.Recognize that time varies with complexity, not technology alone.Conclude the blanket claim is not valid.Verification / Alternative check: Review project schedules showing UI development, integration, and testing often dwarf individual stored-proc coding tasks.
Why Other Options Are Wrong:
- Universal or platform-specific variants do not fix the apples-to-oranges comparison.
Common Pitfalls: Over-centralizing logic in the DB; assuming stored procs eliminate the need for robust middle tiers; ignoring maintainability and versioning.
Final Answer: Does not apply (the claim is generally incorrect)