ExamQuestions.com

Register
Login
Oracle Database Administration I Exam Questions

Oracle

Oracle Database Administration I

37 / 52

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