ocp 11g考試題庫詳解:1Z0-051-085題
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢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正確,可隱式轉換為數值型。