Case Based Critical Thinking QuestionsCase 17-1Maxwell 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

Answer: A

Computer Science & Information Technology

You might also like to view...

Saving a group of objects as a ________ image results in a good-quality picture with a small file size

A) JPEG B) GIF C) TIFF D) PNG

Computer Science & Information Technology

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

A. Group By row B. Total row C. Values row D. Crosstab row

Computer Science & Information Technology