Oracle
1Z0-071 · Question #358
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conversions…
The correct answer is B. invoice_date > '01-02-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 is set to DD-MON-RR. 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
(36 responses)- A11% (4)
- B81% (29)
- C3% (1)
- E6% (2)
Community Discussion
No community discussion yet for this question.