Oracle Database: Advanced PL/SQL — Question 53

Which two are true about implicit data type conversion? (Choose two.)

Answer options

• A. RAW data types are always implicitly converted to a CLOB when used in a query.
• B. Collections can be implicitly converted to records.
• C. ROWIDS are always implicitly converted to a number when used in a query.
• D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
• E. Implicit data type conversion can negatively impact performance.

Correct answer: D, E

Explanation

Answer D is correct because implicit conversions occur to match data types during comparisons, specifically converting character values to numbers as needed. Answer E is also correct as these conversions can introduce overhead, potentially leading to performance issues. The other options are incorrect because they misrepresent the behavior of data type conversions in SQL.