Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?

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?

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
SORT ORDER BY gpa;

B.
SELECT student_id, gpa
FROM student_grades
ORDER BY gpa DESC;

C.
SELECT student_id, gpa
FROM student_grades
ORDER BY gpa ASC;

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
SORT ORDER BY gpa ASC;

Explanation:

:
sorted by highest to lowest is DESCENDING order
Incorrect answer :
* result in ascending order
* wrong syntax with SORT keyword
* wrong syntax with SORT keyword
* default value for ORDER by is in ascending order

* wrong syntax with SORT keyword
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-22



Leave a Reply 0

Your email address will not be published. Required fields are marked *