Oracle
1Z0-071 · Question #327
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)
The correct answer is C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers; E. SELECT NVL2 (cust_credit_limit * .15, `Not Available') FROM customers. See the full explanation below for the reasoning.
Question
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)
Options
- ASELECT NVL (cust_credit_limit * .15, `Not Available') FROM customers;
- BSELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
- CSELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
- DSELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM
- ESELECT NVL2 (cust_credit_limit * .15, `Not Available') FROM customers;
How the community answered
(36 responses)- A8% (3)
- B3% (1)
- C72% (26)
- D17% (6)
Community Discussion
No community discussion yet for this question.