1Z0-007 · Question #15
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4,3) The register has requested a report listing the students' grade point averages (GPA), sorted…
The correct answer is C. SELECT student_id, semester_end, gpa. This answer shows correct syntax and semantics to receive desired result. Incorrect Answers A: Semesters will be sorted started from the oldest date, not the earliest. B: GPA data will be sorted in ascending order, what is opposite to our task. D: Semesters will be sorted…
Question
The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes 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
How the community answered
(25 responses)- A12% (3)
- B4% (1)
- C80% (20)
- E4% (1)
Explanation
This answer shows correct syntax and semantics to receive desired result. Incorrect Answers A: Semesters will be sorted started from the oldest date, not the earliest. B: GPA data will be sorted in ascending order, what is opposite to our task. D: Semesters will be sorted started from the oldest date, not the earliest. Only difference with answer A is order of columns in the ORDER BY clause. E: This query has wrong order of columns to sort: results need to be sorted first by semester, than by grade point average.
Topics
Community Discussion
No community discussion yet for this question.