> > >

Oracle SQL 9i MCQs

Examine the structure of the STUDENTS table given below:

STUDENT_ID    NUMBER    NOT NULL, Primary Key

STUDENT_NAME    VARCHAR2 (30)

COURSE_ID    VARCHAR2 (10)    NOT NULL

MARKS    NUMBER

START_DATE    DATE

FINISH_DATE    DATE

You need to create a report of ten students who achieved the highest ranking in the course INT_SQL and completed the course in the year 1999.
Which of the following SQL statements accomplishes this task?

SELECT student_id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL'ORDER BY marks DESC;

SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99'AND course_id = 'INT_SQL'ORDER BY marks;

SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC);

SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC)WHERE ROWNUM <= 10 ;

SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL';

Answer

Correct Answer: SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL';

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle SQL 9i Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

STUDENT_ID	NUMBER	NOT NULL, Primary Key
STUDENT_NAME	VARCHAR2 (30)
COURSE_ID	VARCHAR2 (10)	NOT NULL
MARKS	NUMBER
START_DATE	DATE
FINISH_DATE	DATE