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)
a).NVL(NULLIF(list_price, min_price), 0)
o/p- 10,000 , 20,000, 0
B.
NVL(COALESCE(list_price, min_price), 0)
o/p- 10,000 ,20,000 ,30,000
C.
NVL2(COALESCE(list_price, min_price), min_price, 0)
o/p – 8000, NULL ,30,000
D.
COALESCE(NVL2(list_price, list_price, min_price), 0)
o/p- 10,000 ,20,000 ,30,000