Oracle
1Z0-071 · Question #329
Examine the description of the EMPLOYEES table: Which query requires explicit data type conversion?
The correct answer is A. SELECT join_date FROM employees WHERE join_date > '10-02-2018'. See the full explanation below for the reasoning.
Question
Examine the description of the EMPLOYEES table:
Which query requires explicit data type conversion?
Exhibit
Options
- ASELECT join_date FROM employees WHERE join_date > '10-02-2018';
- BSELECT salary + `120.50' FROM employees;
- CSELECT SUBSTR(join_date, 1, 2) ?10 FROM employees;
- DSELECT join_date + `20' FROM employees;
- ESELECT join_date ||
|| salary FROM employees;
How the community answered
(44 responses)- A82% (36)
- B5% (2)
- C2% (1)
- D2% (1)
- E9% (4)
Community Discussion
No community discussion yet for this question.
