Exam 1z0-071 topic 1 question 30 discussion

Actual exam question from Oracle's 1z0-071

Question #: 30
Topic #: 1

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week.
Which query can be used?

A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

Show Suggested Answer

Suggested Answer: D 🗳️

by CMjer at May 11, 2023, 6:31 a.m.

Comments

Submit Cancel

yolanda_suny

5 months, 2 weeks ago

Selected Answer: D

This query first uses ADD_MONTHS(hire_date, 6) to calculate the date six months after the hire date, and then uses NEXT_DAY to find the first Monday after this date. This is the correct approach and meets the requirements of the problem.

upvoted 1 times

...

CMjer

1 year, 8 months ago

Selected Answer: D

D is correct. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NEXT_DAY.html#GUID-01B2CC7A-1A64-4A74-918E-26158C9096F6

upvoted 3 times

...

Exam 1z0-071 All Questions

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

Exam 1z0-071 topic 1 question 30 discussion

Comments

yolanda_suny

CMjer

SY0-701