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.
-Parents of some of the beginning soccer players have requested that their children be moved to a team that plays at the field closest to their home.To modify the team field in the current Beginner Soccer League database,Keisha can run a(n)____ query.
A)delete
B)update
C)make-table
D)append

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.
-Parents of some of the beginning soccer players have requested that their children be moved to a team that plays at the field closest to their home.To modify the team field in the current Beginner Soccer League database,Keisha can run a(n)____ query.
A)delete
B)update
C)make-table
D)append

Quizplus · Accepted Answer

An update query allows Keisha to modify the information in the current database, specifically the team field for certain children based on their location. A delete query would remove information rather than modify it, a make-table query would create a new table rather than modify the existing one, and an append query would add new information rather than modify existing information.

Keisha Is Completing an Internship with the Local Parks and Recreation