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?
A.
SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
B.
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
C.
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
D.
SELECT student_id, gpa FROM student_grades ORDER BY gpa;
E.
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
F.
SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
Explanation:
Sorted by highest to lowest is DESCENDING order
Incorrect answer:
A:
result in ascending order
B:
wrong syntax with SORT keyword
C:
wrong syntax with SORT keyword
D:
default value for ORDER by is in ascending order
E:
wrong syntax with SORT keyword
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-22