the studentgrades table has these columns studentid number 12 semesterend date..., Oracle SQL 9i, Databases

Test
- Model Test
Index

Question: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?

A SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL; 
B SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL; 
C SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end; 
D SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades; 
E SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

/45

+ AnswerC

+ Report

Descriptive on Oracle SQL 9i Ebook

Total Preview: 10603

Question: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?

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

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

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

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

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

C