ocp 11g考試題庫(kù)詳解：1Z0-051-098題，完整題庫(kù)請(qǐng)點(diǎn)擊這里聯(lián)系老師咨詢了解

98. Which statement is true regarding the COALESCE function?

A. It can have a maximum of five expressions in a list. 

B. It returns the highest NOT NULL value in the list for all rows.

C. It requires that all expressions in the list must be of the same data type.

D. It requires that at least one of the expressions in the list must have a NOT NULL value.

Answer: C

A 最多只能有5個(gè)表達(dá)式，錯(cuò)，無(wú)限個(gè)

B 返回最高的非空值，錯(cuò)，返回第一個(gè)非空值

C 所有都要相同的類型

D 至少有一個(gè)不是空值，錯(cuò)，可以都是空值，則返回空值