Oracle Exam 1Z0-082 Topic 12 Question 79 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 79
Topic #: 12

[All 1Z0-082 Questions]

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

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

Show Suggested Answer

Suggested Answer: E, F

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm

by Ahmed at Aug 29, 2023, 02:18 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sylvia

8 days ago

Option B and C are also correct, as the date string '15-march-2019' and '01-02-2019' are implicitly converted to the DATE data type.

upvoted 0 times

...

Gabriele

16 days ago

Option A is correct, as CONCAT requires explicit conversion of the numeric QTY_SOLD column to a string. Implicit conversion is not possible in this case.

upvoted 0 times

Ariel

1 days ago

User1: Option A is correct because CONCAT requires explicit conversion of the numeric QTY_SOLD column to a string.

upvoted 0 times

...

Billi

24 days ago

I believe option C is also true as it involves implicit conversion.

upvoted 0 times

...

Viva

26 days ago

I agree with Johanna. Option B makes sense in this context.

upvoted 0 times

...

Johanna

29 days ago

I think option B is true because it uses implicit conversion.

upvoted 0 times

...