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…

Question

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;

• A
  8% (3)
• C
  3% (1)
• D
  13% (5)
• E
  3% (1)
• F
  74% (29)

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

No community discussion yet for this question.