Exam 1z1-071 Topic 1 Question 137 Discussion
Actual exam question for Oracle's 1z1-071 exam
Question #: 137
Topic #: 1
Question #: 137
Topic #: 1
Examine the description of the EMPLOYEES table:

For each employee in department 90 you want to display:
1. their last name
2. the number of complete weeks they have been employed
The output must be sorted by the number of weeks, starting with the longest serving employee first.
Which statement will accomplish this?

For each employee in department 90 you want to display:
1. their last name
2. the number of complete weeks they have been employed
The output must be sorted by the number of weeks, starting with the longest serving employee first.
Which statement will accomplish this?
Suggested Answer: C Vote an answer
by Jonathan at Jul 16, 2026, 11:10 AM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).