Exam 1z0-071 topic 1 question 49 discussion

its asking for complete weeks so its B

B. Rounding up gives then employees extra days for their "complete" weeks. B would make more sense.

B. its asking for completed weeks (TRUNC not ROUND) and order by DESC.

Moderator, please change the correct answer to B. Currently it is C which is incorrect as the order needs to be descending.

There is no department in the table.. I also vote for B because of complete weeks, starting from longest period of time

The answer should be changed to A or B because both are correct. By no means C is correct, it violates the last requirement LONGEST SERVING ON TOP.

b is correct

A & B, Both are correct. More precise is B. The requirement “output must be sorted by the number of weeks, starting with the longest” means the sorting order MUST be DESC on Tenure (High -- Low) Since in C & D, the order by tenure will adopt ASC by default, it will be from low -High so lowest tenure will be on top of output and highest tenure at bottom.

B is the correct answer

Are you kidding me? Why paying for incorrect answers? Obviously the answer is B!

Answer B. Complete weeks with trunc

B would be more accurate since it does not give extra days by rounding

how to filter department = 90 when theres no Department or Dept_ID in the table... All options must be wrong.

Answer is B, complete weeks.

I would say A. If we have 5 working days in a week, then Round will give us the correct result. And as we were asked to show employees, who serves longer, first, then we should order by desc. So, I do not understand why correct answer is C ...

Answer is B, complete weeks.

B correct