106.Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:

106.Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:

LIST_PRICE MIN_PRICE
10000      8000
20000
30000      30000
Which two expressions give the same output? (Choose two.)
A.NVL(NULLIF(list_price, min_price), 0)
B.NVL(COALESCE(list_price, min_price), 0)
C.NVL2(COALESCE(list_price, min_price), min_price, 0)
D.COALESCE(NVL2(list_price, list_price, min_price), 0)
答案：BD
解析：
对于上面三条数据，分别是
A:10000,20000，0
B:10000,20000,30000
C:8000,null,30000
D:10000,20000,30000