Oracle
1Z0-007 · Question #187
1Z0-007 Question #187: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #187. 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 registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?
Options
- ASELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
- BSELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
- CSELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
- DSELECT student_id, gpa FROM student_grades ORDER BY gpa;
- ESELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
- FSELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
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.