Oracle
1Z0-082 · Question #145
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.
SQL and PL/SQL
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 join_date I I ' ' II salary FROM employees;
- CSELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;
- DSELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
How the community answered
(31 responses)- A74% (23)
- B13% (4)
- C6% (2)
- D6% (2)
Topics
#explicit conversion#implicit conversion#data types#TO_DATE
Community Discussion
No community discussion yet for this question.