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:

Public Goods

Goods or services that are available for all to consume, regardless of payment, such as public parks or national defense.

Economic Efficiency

A situation in which every resource is optimally allocated to serve each individual or entity in the best way while minimizing waste and inefficiency.

Economic Efficiency

An arrangement where resources are managed to achieve the greatest output of goods and services.

Copper Products

Items or merchandise that are made from copper, including electrical wiring, plumbing materials, and decorative objects.