Examine the description of the EMPLOYEES table:
Which query requires explicit data type conversion?
A. SELECT join_date FROM employees WHERE join_date > ’10-02-2018′;
B. SELECT salary + ‘120.50’ FROM employees;
C. SELECT SUBSTR(join_date, 1, 2) – 10 FROM employees;
D. SELECT join_date + ’20’ FROM employees;
E. SELECT join_date || ‘ ‘ || salary FROM employees;
|
Download Printable PDF. VALID exam to help you PASS. |
 |
A6
A
E