Oracle
1Z0-074 · Question #86
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT Which two are true about data type conversions involving these columns in…
The correct answer is C. invoice_date = '15-march-2019' : uses implicit conversion D. qty_sold BETWEEN `101' AND `110' : uses implicit conversion. See the full explanation below for the reasoning.
Question
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT Which two are true about data type conversions involving these columns in query expressions? (Choose two.)
Options
- ACONCAT(qty_sold, invoice_date) : requires explicit conversion
- Binvoice_date > '01-02-2019' : uses implicit conversion
- Cinvoice_date = '15-march-2019' : uses implicit conversion
- Dqty_sold BETWEEN
101' AND110' : uses implicit conversion - Eqty_sold = `0554982' : requires explicit conversion
How the community answered
(27 responses)- A11% (3)
- B4% (1)
- C81% (22)
- E4% (1)
Community Discussion
No community discussion yet for this question.