Case-Based Critical Thinking Questions

Multiple Choice

Case-Based Critical Thinking Questions
Case 9-1
Keisha is completing an internship with the local parks and recreation department.  She has been asked to update and maintain the beginning soccer league database for children ages 3-4.  The league consists of over 150 children and 10 soccer teams.  The teams play at two different soccer fields in the city.  The database already exists from last year so Keisha will not be developing the database.  She will only make changes as necessary to the current database.
-Keisha does not want information about beginning soccer players from the past year in the Beginner Soccer League database for the current year. She may run a(n) ____ query with selected criteria such as year and team name to remove last year's players.

A) update
B) append
C) delete
D) make-table