> > >

Oracle SQL 9i MCQs

The STUDENT_GRADES table has these columns:

STUDENT_ID NUMBER (12)

SEMESTER_END DATE
GPA NUMBER (4, 3)

Which of the following statements finds the highest Grade Point Average (GPA) per semester?

SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;

SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;

SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL; <br>

Answer

Correct Answer: SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle SQL 9i Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it