Oracle
1Z0-071 · Question #144
View and Exhibit and examine the structure and data in the INVOICE table. Which two statements are true regarding data type conversion in query expressions? (Choose two.)
The correct answer is A. inv_date = '15-february-2008' :uses implicit conversion E. inv_no BETWEEN '101' AND '110' : uses implicit conversion. See the full explanation below for the reasoning.
Question
View and Exhibit and examine the structure and data in the INVOICE table. Which two statements are true regarding data type conversion in query expressions? (Choose two.)
Options
- Ainv_date = '15-february-2008' :uses implicit conversion
- Binv_amt = '0255982' : requires explicit conversion
- Cinv_date > '01-02-2008' : uses implicit conversion
- DCONCAT(inv_amt, inv_date) : requires explicit conversion
- Einv_no BETWEEN '101' AND '110' : uses implicit conversion
How the community answered
(53 responses)- A79% (42)
- B6% (3)
- C4% (2)
- D11% (6)
Community Discussion
No community discussion yet for this question.