高階ICT-DBAS-015
A query uses Form = 5 AND House = "Red". Which rows are returned?
A. Every Form 5 row, plus every Red House row from other forms.
B. Only rows that fail both tests.
C. No rows, because AND deletes the two fields.
D. Only rows that are Form 5 and also Red House.✓ 答案
解說
AND keeps a row only when both criteria are true. OR would keep a row that matches either criterion. The fields stay in the table.