The STUDENT_GRADES table has these columns: The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which…

The correct answer is D. SELECT AVG (gpa). Statement in this answer will show correct result, using function AVG(). This function takes the values for a single column on all rows returned by the query and calculates the average value for that column. Incorrect Answers A: There is no AVERAGE() function in Oracle. B…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

The STUDENT_GRADES table has these columns:

The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?

Options

ASELECT AVERAGE (gpa)
BSELECT COUNT (gpa)
CSELECT MIN (gpa)
DSELECT AVG (gpa)
ESELECT SUM (gpa)
FSELECT MEDIAN (gpa)

How the community answered

(33 responses)

A
12% (4)
B
3% (1)
C
3% (1)
D
76% (25)
F
6% (2)

Explanation

Statement in this answer will show correct result, using function AVG(). This function takes the values for a single column on all rows returned by the query and calculates the average value for that column. Incorrect Answers A: There is no AVERAGE() function in Oracle. B: COUNT() will calculate number of row, not an average grade point. C: MIN() function will calculate minimum grade for all students enrolled during semesters that end in the year 2000. E: SUM() will calculate sum of all grade points for all students enrolled during semesters that end in the year 2000. F: There is no MEDIAN() function in Oracle.

Topics

#AVG function#aggregate functions#GROUP BY#GPA report

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice