Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 184

Examine the description of the EMPLOYEES table:

NLS_DATE_FORMAT is set to DD-MON-YY.

Which query requires explicit data type conversion?

SELECT join_date FROM employees WHERE join_datee > ’10-02-2018’;

SELECT join_date || ‘ ‘ || salary FROM employees;

SELECT salary + ’120.50’ FROM employees;

SELECT join_date + ‘20’ FROM employees;

SELECT SUBSTR(join_date, 1, 2) -1’

Correct Answer: A

The query that requires explicit data type conversion is: SELECT join_date FROM employees WHERE join_date > '10-02-2018';. In this query, the date format '10-02-2018' does not match the NLS_DATE_FORMAT which is set to DD-MON-YY. The correct format should be '10-FEB-18'. Therefore, to execute this query correctly, the string '10-02-2018' needs to be explicitly converted to a date using the TO_DATE() function in the correct format.

Discussion

lucemqyOption: A

A is the correct answer

CyberPOption: A

https://www.examtopics.com/discussions/oracle/view/13453-exam-1z0-071-topic-1-question-296-discussion/

MooonLight

All executed without error.

jfc1Option: A

D is executed without conversion. A is the correct