View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT firstₙame, employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) “Review” FROM employees; The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID, and review date for employees. The review date is the firsts Monday after the completion ofsix months of the hiring. The NLS_TERRITORY parameter is set to AMERICA in the session. Which statement is true regarding this query?

Question

Examsnet · Accepted Answer

Correct Answer is : The query would execute but the output would give review dates that are Sundays.

Oracle Database SQL 12c 1z0-071 Exam Practice Test 3