7
QuizMultiple Choice

Introduction

Question 7 • Introduction to Information Technology - EL3701

Samantha’s database contains a table of student scores and another table with student schedules. How can Samantha use this information to help her decide how to group students for review class?

Answer
A
She can use a simple query to sort the scores in ascending order.
B
She can use a simple query to group student scores by name.
C
She can use a complex query linking student scores by name and available study period, then sort the data and group it.
D
She can use a complex query to retrieve all scores below 65.

Explanation

To form useful review groups, Samantha needs to combine each student’s score with their schedule so she can identify both who needs review and when they are available. A complex query can link the two tables using student name, then sort the results and group students by a suitable study period. Sorting scores alone or grouping scores by name does not account for availability, while retrieving only scores below 65 leaves out the scheduling information.

AI-written and checked against the verified answer.

Previous
Next