Oracle
1Z0-061 · Question #146
The STUDENT_GRADES table has these columns: STUDENT_ID. NUMBER(12) SEMESTER_END. DATE GPA. NUMBER(4, 3) The registrar has asked for a report on the average grade point average (GPA), sorted from the…
The correct answer is F. SELECT student_id, semester_end, gpa. See the full explanation below for the reasoning.
Question
The STUDENT_GRADES table has these columns:
STUDENT_ID. NUMBER(12) SEMESTER_END. DATE GPA. NUMBER(4, 3) The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date. Which statement accomplish this?
Options
- ASELECT student_id, semester_end, gpa
- BSELECT student_id, semester_end, gpa
- CSELECT student_id, semester_end, gpa
- DSELECT student_id, semester_end, gpa
- ESELECT student_id, semester_end, gpa
- FSELECT student_id, semester_end, gpa
How the community answered
(55 responses)- B2% (1)
- C9% (5)
- D2% (1)
- E4% (2)
- F84% (46)
Community Discussion
No community discussion yet for this question.