Oracle
1Z0-061 · Question #233
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…
The correct answer is F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC. Sorted by highest to lowest is DESCENDING order
Restricting and Sorting Data
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;
How the community answered
(19 responses)- A5% (1)
- B5% (1)
- D16% (3)
- F74% (14)
Explanation
Sorted by highest to lowest is DESCENDING order
Topics
#ORDER BY#DESC#sorting#SELECT statement
Community Discussion
No community discussion yet for this question.