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

Question

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

Quizplus · Accepted Answer

The best choice is to use a delete query with selected criteria such as year and team name to remove last year's players from the database. The update query would only modify existing data, the append query would add new data, and the make-table query would create a new table. None of these options would effectively remove the desired information from the existing database.