中等ICT-DBAS-011
A birthday should be stored in a field of type:
A. Date.✓ 答案
B. Yes/no, because a birthday is a choice.
C. Bitmap.
D. Untyped text, so that 31/02/2020 can be kept on purpose.
解說
A date field can reject impossible dates and can be sorted in calendar order. A yes/no field cannot hold a full date, and free text makes bad dates easy to store.