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;
Submitted by: AdministratorB. 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;
Submitted by: Administrator
FROM customers
ORDER BY cust_credit_limit;
C. SELECT cust_last_name,cust_credit_limit
FROM customers
ORDER BY cust_credit_limit NULLS LAST;
Submitted by: Administrator
Read Online Oracle Certification Job Interview Questions And Answers
Top Oracle Certification Questions
☺ | Explain Which three statements/commands would cause a transaction to end? (Choose three.) |
Top Certifications Categories
☺ | CCIE Certification Interview Questions. |
☺ | CCSP Certification Interview Questions. |
☺ | AFMC Interview Questions. |
☺ | Sun Certification Interview Questions. |
☺ | CCDA Certification Interview Questions. |