A piece of the Student Info table in the Harris Community College database is shown below. What information could an instructor find by querying this table in the database?

ID#

FirstName LastName StudentMajor Address

1

Beth Borsky Art 55 Winsap Ln.

2

Hank Hoff Chemistry 7 Gosling Rd.

3

Stephanie Serle Political Science 136 Finley Ave.

4

Rafi Rohr Art 55 W. 79th St.

a list of students over the age of 35

a list of students grouped by major

a list of students who got over a 90% on the entrance exam

a list of all male students

Question

Amy Curtis

Business

9 May, 08:58

A piece of the Student Info table in the Harris Community College database is shown below. What information could an instructor find by querying this table in the database?

ID#

FirstName LastName StudentMajor Address

1

Beth Borsky Art 55 Winsap Ln.

2

Hank Hoff Chemistry 7 Gosling Rd.

3

Stephanie Serle Political Science 136 Finley Ave.

4

Rafi Rohr Art 55 W. 79th St.

a list of students over the age of 35

a list of students grouped by major

a list of students who got over a 90% on the entrance exam

a list of all male students

+2

Answers (1)

Know the Answer?

Meyers · Answer 1

The correct answer is a list of students grouped by major. Querying this table will give a list of all students grouped by major as the table contains a list of a students and a field that lists their major. The table does not have gender, age or the grade that they scored.