Examine the structure of the STUDENTS table:
You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.
Which SQL statement accomplishes this task?
A. SELECT student_ id, marks, ROWNUM "Rank"FROM studentsWHERE ROWNUM <= 10AND finish_date BETWEEN ’01-JAN-99′ AND ’31-DEC- 99AND course_id = ‘INT_SQL’ORDER BY marks DESC;
B. SELECT student_id, marks, ROWID "Rank"FROM studentsWHERE ROWID <= 10AND finish_date BETWEEN ’01-JAN-99′ AND ’31-DEC-99’AND course_id = ‘INT_SQL’ORDER BY marks;
C. SELECT student_id, marks, ROWNUM "Rank"FROM (SELECT student_id, marksFROM studentsWHERE ROWNUM <= 10AND finish_date BETWEEN ’01-JAN-99′ AND ’31-DEC-99’AND course_id = ‘INT_SQL’ORDER BY marks DESC);
D. SELECT student_id, marks, ROWNUM "Rank”FROM (SELECT student_id, marksFROM studentsWHERE (finish_date BETWEEN ’01-JAN-99 AND ’31-DEC-99’AND course_id = ‘INT_SQL’ORDER BY marks DESC)WHERE ROWNUM <= 10 ;
E. SELECTstudent id, marks, ROWNUM “Rank”FROM(SELECT student_id, marksFROM studentsORDER BY marks)WHEREROWNUM <= 10ANDfinish date BETWEEN ’01-JAN-99′ AND ’31-DEC-99’ANDcourse_id = ‘INT_SQL’;
|
Download Printable PDF. VALID exam to help you PASS. |
 |