Case Based Critical Thinking Questions Case 17-1 Maxwell Has Developed

Multiple Choice

Case Based Critical Thinking Questions Case 17-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Kyra asks how to select all movies that received an award between 1940 and 1955. Maxwell tells her that the query criteria for the Award Year field should be: _____.

A) >= 1940 AND <= 1955
B) >= 1940 OR <= 1955
C) = 1940 AND = 1955
D) HIGHER THAN 1940 AND LOWER THAN 1955