Oracle Exam 1Z0-082 Topic 3 Question 15 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 15
Topic #: 3

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.

Which two queries execute successfully? (Choose two.)

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 customers;

Show Suggested Answer

Suggested Answer: C, E

by Sharika at May 07, 2022, 06:11 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!