The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)

Question

Options

• ASELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
• BSELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
• CSELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• DSELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
• ESELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM

• A
  7% (2)
• B
  74% (20)
• D
  4% (1)
• E
  15% (4)

No community discussion yet for this question.