Question 37:
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.)
Answer options:
A. CONCAT (qty_sold, invoice_date) : requires explicit conversion B. invoice_date = `15-march-2019` : uses implicit conversion C. invoie_date > `01-02-2019` : uses implicit conversion D. qty_sold BETWEEN "˜101` AND `110` : uses implicit conversion E. qty_sold = "˜0554982` uses implicit conversion