Oracle
1Z0-082 · Question #95
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 = '15-march-2019' : uses implicit conversion D. qty_sold BETWEEN `101' AND '110' : uses implicit conversion. You've hit your weekly limit · resets 5am (America/New_York)
SQL and PL/SQL
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 = '15-march-2019' : uses implicit conversion
- Cinvoie_date > '01-02-2019' : uses implicit conversion
- Dqty_sold BETWEEN `101' AND '110' : uses implicit conversion
- Eqty_sold = `0554982' uses implicit conversion
How the community answered
(30 responses)- A13% (4)
- B77% (23)
- C7% (2)
- E3% (1)
Explanation
You've hit your weekly limit · resets 5am (America/New_York)
Topics
#implicit conversion#explicit conversion#NLS_DATE_FORMAT#data type conversion
Community Discussion
No community discussion yet for this question.