Creating a Database

Question 1 • VA-Information Technology Fundamentals B

Which queries would help you answer the question “Are there any employees in Tucson?” using the Employee database. Select all that apply.

Answer

Select City data and then Run Query.

Select the Employee data, Sort ascending, and Run Query.

Select the City data, add the criterion Tucson, and Run Query.

Select the City data, use the Maximum function, and Run Query.

Select the City data, use ascending Sort, and Run Query.

Explanation

Selecting the City data and running the query displays the city values, so you can check whether Tucson appears. Adding Tucson as a criterion directly checks for matching employees, and sorting the City data still lets you scan the listed cities for Tucson. Sorting Employee data or finding the maximum City value does not directly answer whether anyone works in Tucson.

AI-written and checked against the verified answer.

Back to All Questions

More from this Course

Creating a Database

Creating a Database

Using Reports to Communicate Data