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正确，可隐式转换为数值型。