Oracle
1Z0-007 · Question #15
1Z0-007 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
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
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.