Exam 1z0-082 topic 1 question 41 discussion

I double checked this Question, B is correct ! the Setting of NLS_TERRITORY changed the behavior

"The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week." 1 is Sunday in that case. Correct answer is B.

A - false; query returns emp_id and two dates where any of those dates does not meet required conditions B - true; 6 months are added to hire_date properly with ADD_MONTHS, then first monday following the date is found with NEXT_DAY function C - false; function MONTHS_BETWEEN returns the number of months, which is a NUMBER value. This number is then first argument of NEXT_DAY which accepts DATE value as its first parameter. Therefore an error "ORA-00932: inconsistent datatypes: expected DATE got NUMBER" occurs. D - false; it’s very similar to B and almost correct/true. Key information is NLS_TERRITORY=AMERICA : number 1 as a week day number links to Sunday. If NLS_TERRITORY was set to some European country, number 1 would link to Monday and both queries (B, D) would return the same results.

B is correct

what is "˜MONDAY' ? but not 'MONDAY' is it my browser problem?

B is correct

A is wrong. The NEXT_DAY function needs 2 arguments to work. NEXT_DAY returns the date of the first weekday named by char that is later than the date date. B is correct. First we add 6 months to the hire date using the ADD_MONTHS function, then passing that date value to the NEXT_DAY function. C is wrong. Issues with both the MONTHS_BETWEEN function (wrong usage and argument order) and the NEXT_DAY function (second argument should be a day name). D is wrong. Not because of the usage but because of the Day returned. Using a "1" as the second argument in the NEXT_DAY function it returns a Sunday date and not the first Monday. Looking at the official Oracle documentation the second argument should be character (day name) only. "The argument char must be a day of the week in the date language of your session, either the full name or the abbreviation." Just goes to show that 1, Oracle documentation is never 100% complete and 2, test test test if you are not sure.

B is correct

ALTER SESSION SET NLS_TERRITORY = "AMERICA"; SELECT employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees; Result = 22-DEC-03 (Monday) SELECT employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees; Result = 21-DEC-03 (Sunday) Correct answer is B!

D is correct

Today is 24.06.2020... SQL> alter session set nls_date_format='DD.MM.YYYY'; Session wurde geandert. SQL> SQL> SQL> select sysdate, NEXT_DAY(ADD_MONTHS(sysdate, 6), 1) from dual; SYSDATE NEXT_DAY(A ---------- ---------- 24.06.2020 28.12.2020 The first Monday after six months is 28.12.2020 > so correct answer must be D