Question

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?
She can use a simple query to sort the scores in ascending order.
She can use a simple query to group student scores by name.
She can use a complex query linking student scores by name and available study period, then sort the data and group it.
She can use a complex query to retrieve all scores below 65.

Answer 1

The correct answer is She can use a complex query linking student scores by name and available study period, then sort the data and group it. By doing this, she would have used both tables to make a decision on how to group the students for a review class.

Answer 2

Answer:

The Correct answer would be C, She can use a complex query linking students scores by name and available study period, then sort the data and group it.

Explanation:

Databases are used to store large number of data. Data are stored in the form of tables. These data can be identified by using the special keys for each table. Every table has a unique identification key, which is called the Primary key for that table and data can be retrieved by putting a query in the database. So in this example, Samantha wants to make groups of students according to their scores and time tables/schedules. So she has to use a complex query to link these two tables of student scores and student schedule to sort them in another table.