Oracle
1Z0-007 · Question #119
The STUDENT_GRADES table has these columns: 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 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:
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
(38 responses)- B3% (1)
- C11% (4)
- D5% (2)
- E3% (1)
- F79% (30)
Community Discussion
No community discussion yet for this question.