Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

© examsiri.com

Question : 40 of 57

Marks: +1, -0

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.)

CONCAT(qty_sold, invoice_date) : requires explicit conversion
invoice_date > ’01-02-2019’ : uses implicit conversion
invoice_date = ’15-march-2019’ : uses implicit conversion
qty_sold BETWEEN ‘101’ AND ‘110’ : uses implicit conversion
qty_sold = ‘0554982’ : requires explicit conversion

Go to Question:

Prev Question

Next Question