ocp 11g考题大全：1Z0-051-085题
来源：优技教育
ocp 11g考题大全：1Z0-051-085题，完整题库请点击这里联系老师咨询了解
85. View the E xhibit and examine the structure and data in the INVOICE table.
Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.)
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
Answer: DE
试题解析：
A隐式转换为数值型，不用显示转换，错误。
B错误，只能用to_date显示转换为特定的格式。
C错误，隐式转换为字符型
D正确，此格式玉默认的格式相融合，可隐式转换
E正确，可隐式转换为数值型。
精华阅读