Oracle
1Z0-061 · Question #93
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
(36 responses)- A6% (2)
- B3% (1)
- C11% (4)
- D78% (28)
- E3% (1)
Community Discussion
No community discussion yet for this question.