ocp 11g認證題庫詳解:1Z0-051-073題
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢ocp 11g認證題庫詳解:1Z0-051-073題,完整題庫請點擊這里聯系老師咨詢了解
73. Which tasks can be performed using SQL functions that are built into Oracle database ? (Choose three .)
A. finding the remainder of a division
B. adding a number to a date for a resultant date value
C. comparing two expressions to check whether they are equal
D. checking whether a specified character exists in a given string
E. removing trailing, leading, and embedded characters from a character string
Answer: ACD
試題解析:
A. 取余,如MOD()
B. 給日期添加一個數字合成一個日期值,個人覺得可以使用ADD_MONTHS(),含義上也是一個日期加上一個數字等于另外一個日期。
C. 比較兩個表達式查看是否相等,例如NULLIF
D. 檢查指定的字符串是否存在另一個字符串中,例如,INSTR()
E. 從一個字符串中移除尾部,前部,內含的字符,trim()只能去除前后的字符