Oracle
1Z0-007 · Question #117
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…
The correct answer is D. SELECT student_id, marks, ROWNUM "Rank". See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASELECT student_ id, marks, ROWNUM "Rank"
- BSELECT student_id, marks, ROWID "Rank"
- CSELECT student_id, marks, ROWNUM "Rank"
- DSELECT student_id, marks, ROWNUM "Rank"
- ESELECT student id, marks, ROWNUM "Rank"
How the community answered
(43 responses)- B9% (4)
- C5% (2)
- D84% (36)
- E2% (1)
Community Discussion
No community discussion yet for this question.