1z0-061 Free Dumps Study Materials
Question 8: View the Exhibit and examine the structure and data in the INVOICE table.
Which two statements are true regarding data type conversion in expressions used in queries?
A. inv_amt ='0255982': requires explicit conversion
B. inv_date > '01-02-2008': uses implicit conversion
C. CONCAT (inv_amt, inv_date): requires explicit conversion
D. inv_date = '15-february-2008': uses implicit conversion
E. inv_no BETWEEN '101' AND '110': uses implicit conversion
Correct Answer: D,E
Explanation:
In some cases, the Oracle server receives data of one data type where it expects data of a different
data type.
When this happens, the Oracle server can automatically convert the data to the expected data type.
This data type conversion can be done implicitly by the Oracle server or explicitly by the user.
Explicit data type conversions are performed by using the conversion functions. Conversion functions
convert a value from one data type to another. Generally, the form of the function names follows the
convention data type TO data type. The first data type is the input data type and the second data
type is the output.
Note: Although implicit data type conversion is available, it is recommended that you do the explicit
data type conversion to ensure the reliability of your SQL statements.