Answers

Question and Answer:

  Home  Oracle Certification

⟩ Suppose you need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result? (Choose two.) A. SELECT cust_last_name,cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC; B. SELECT cust_last_name,cust_credit_limit FROM customers ORDER BY cust_credit_limit; C. SELECT cust_last_name,cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST; D. SELECT cust_last_name,cust_credit_limit FROM customers ORDER BY cust_last_name,cust_credit_limit NULLS LAST;

B. SELECT cust_last_name,cust_credit_limit

FROM customers

ORDER BY cust_credit_limit;

C. SELECT cust_last_name,cust_credit_limit

FROM customers

ORDER BY cust_credit_limit NULLS LAST;

 213 views

More Questions for you: