READ Free Dumps For Oracle- 1z0-007
Question ID 8037 | The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date. Which statement accomplish this? |
Option A | SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semesterend DESC, gpa DESC; |
Option B | SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa ASC |
Option C | SELECT student_id, semesterend, gpa FROM student_grades ORDER BY gpa DESC, semesterend ASC; |
Option D | SELECT student_id, semesterend, gpa FROM student_grades ORDER BY gpa DESC, semesterend DESC; |
Option E | SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semesterend ASC; |
Option F | SELECT student_id,semester_end,gpa FROM studentgrades ORDER BY semester_end,gpa DESC |
Question ID 8038 | Which are /SQL*Plus commands? (Choose all that apply.) |
Option A | INSERT |
Option B | UPDATE |
Option C | SELECT |
Option D | DESCRIBE |
Option E | DELETE |
Option F | RENAME |
Correct Answer | A, B, C, D |