Exam 1z0-071 topic 1 question 245 discussion

Actual exam question from Oracle's 1z0-071

Question #: 245
Topic #: 1

Examine the description of the EMPLOYEES table:

Examine these requirements:

1. Display the last name, date of hire and the number of years of service for each employee.
2. If the employee has been employed 5 or more years but less than 10, display “5+ years of service”.
3. If the employee has been employed 10 or more years but less than 15, display “10+ years of service”.
4. If the employee has been employed 15 or more years, display “15+ years of service”.
5. If none of these conditions matches, display “<5 years of service”.
6. Sort the results by the HIRE_DATE column.

Which statement satisfies all the requirements?

Show Suggested Answer

Suggested Answer: D 🗳️

by billysunday1 at March 30, 2024, 8:28 a.m.

Comments

Submit Cancel

ArslanAltaf

2 months ago

Logic has to be higher to lower otherwise condition will not address 2nd row D is correct select last_name, hire_date, Case When sysdate - to_yminterval ('20-0') >= hire_date then 'Older than 20 years Employees' When sysdate - to_yminterval ('10-0') >= hire_date then 'Older than 10 years Employees' When sysdate - to_yminterval ('5-0') >= hire_date then 'Older than 5 years Employees' Else 'New Employees' END as "Employees Duration" from emp order by "Employees Duration" desc ;

upvoted 2 times

...

khaleesi89

2 months, 3 weeks ago

Selected Answer: D

Correct answer is D SELECT e.last_name, hire_date, sysdate, (CASE WHEN (sysdate -TO_YMINTERVAL('15-0')) >= hire_date THEN '15 years of service' WHEN (sysdate -TO_YMINTERVAL('10-0')) >= hire_date THEN '10 years of service' WHEN (sysdate - TO_YMINTERVAL('5-0')) >= hire_date THEN '5 years of service' ELSE '<5 years of service' END) AS years FROM employees ORDER BY hire_date

upvoted 4 times

...

billysunday1

3 months, 1 week ago

Selected Answer: B

I think answer is B.

upvoted 1 times

khaleesi89

2 months, 3 weeks ago

It cannot be B TO_YMINTERVAL must be to the left of the operator of the comparation and must be used to deduct a date

upvoted 1 times

...

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Exam 1z0-071 topic 1 question 245 discussion

Comments

ArslanAltaf

khaleesi89

billysunday1

khaleesi89

SY0-701