Difficulty: Easy
Correct Answer: correct spelling changes before they are recorded
Explanation:
Introduction / Context:
Data entry workflows often buffer edits in memory until a user confirms or saves. This buffer allows on-the-spot corrections to record values. However, schema alterations—renaming fields or changing field widths—are design-time operations, not per-record value edits.
Given Data / Assumptions:
Concept / Approach:
Buffered editing supports correcting content such as spelling, formatting, or numeric entry errors. In contrast, changing a field’s name or width modifies the schema and requires DDL changes, not a simple pre-save value edit. Therefore, the enabled action is to correct spelling (a value-level fix) before committing the record to storage.
Step-by-Step Solution:
Verification / Alternative check:
Common CRUD forms allow user edits and validations prior to save; schema changes require administrative privileges and DDL execution.
Why Other Options Are Wrong:
Change name/width of a field: Requires altering table definitions; not a per-record pre-save edit.
All of the above: Mixes data editing with schema management—incorrect.
Common Pitfalls:
Confusing UI-level edits with design-time schema maintenance; they occur in different layers and permission scopes.
Final Answer:
correct spelling changes before they are recorded
Discussion & Comments