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

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 the "delete" query to remove any information from last year's players in the database. This can be done by selecting criteria such as the year and team name to ensure that only the relevant records are deleted. Updating would imply changing the information rather than removing it, and appending and make-table are not relevant for this task.

Keisha Is Completing an Internship with the Local Parks and Recreation