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's supervisor has asked that she provide her with a table showing all of the soccer teams and the team schedules.This table will only be used once to schedule coaches.Which type of query should Keisha run?
A)make-table
B)append
C)delete
D)update

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's supervisor has asked that she provide her with a table showing all of the soccer teams and the team schedules.This table will only be used once to schedule coaches.Which type of query should Keisha run?
A)make-table
B)append
C)delete
D)update

Quizplus · Accepted Answer

Keisha should run a make-table query to create a new table that includes all the soccer teams and their schedules. This new table can be used by her supervisor to schedule coaches without changing the current database. Running an append query would add new records to an existing table, which is not necessary in this case. Delete and update queries would not be appropriate for creating a new table or providing schedules.

Keisha Is Completing an Internship with the Local Parks and Recreation