Assume the Following Table Named Student Exists in a Database

question 25

Multiple Choice

Assume the following table named Student exists in a database:

Which of the following SQL statements will return only the student name and GPA from the Student table for all students having a GPA that is greater than or equal to 3.5?

• A) SELECT Name, GPA FROM Student WHERE GPA >=3.5
• B) SELECT * FROM Student WHERE GPA >= 3.5
• C) SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA >= 3.5
• D) SELECT Student WHERE GPA >= 3.5 And Name, GPA

---

Definitions:

Variance

A statistic that measures the spread between numbers in a data set, indicating how far each number in the set is from the mean.

Standard Deviation

A measure of the amount of variation or dispersion of a set of values, indicating how much the members of a group differ from the mean value of the group.

Test Statistic

A value derived from sample data that is utilized to determine the rejection of the null hypothesis in statistical hypothesis testing.

Producer

An individual, company, or entity that creates or supplies goods or services.