Oracle
1Z0-061 · Question #233
1Z0-061 Question #233: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #233. 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-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.