中等ICT-DBAS-008
A mark field accepts only values from 0 to 100. The true mark is 60, but the clerk types 70. What happens?
A. The range check proves that 70 is the true mark.
B. The range check rejects 70.
C. The database reports a syntax error.
D. 70 is inside the range, so the range check does not catch the mistake.✓ 答案
解說
Validation tests whether the value is reasonable, not whether it is true. 70 is allowed. Only a check against the original script would catch the swap.