OCP CBT Question 496

Please solve the following question.

Which statement is true regarding the implicit and explicit conversion of data types in Oracle SQL?

Implicit conversion always occurs when a CHAR or VARCHAR2 value is compared with a NUMBER value, converting the character value to a number.

Explicit conversion is performed by Oracle automatically when necessary, without the use of conversion functions.

Implicit conversion can lead to unexpected errors or performance issues because it depends on Oracle's internal conversion rules.

The TO_NUMBER function can implicitly convert any string to a number, even if the string contains non-numeric characters.