可学答题网 > 问答 > OCP 11G认证考试题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You need to generate


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?()

  • ASELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC
  • BSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit
  • CSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST
  • DSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
参考答案
参考解析:
分类:OCP 11G认证考试题库
相关推荐

1、You need to evaluate

You need to evaluate whether the currently available network bandwidth is adequate to r...

2、You need to design&#

You need to design Group Policy object (GPO) settings to support the use of the...

3、You need to design&#

You need to design a security strategy for VPN2. Your solution must meet business&#8194...

4、You need to provide&

You need to provide users in the research department access to different functions of&#...

5、You need to ensure&#

You need to ensure that the company’s standard password policy is enforced for all&#81...

6、You need to design&#

You need to design a patch management strategy for Northwind Traders. What should you&#...