（多选题）
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
正确答案
答案解析
略
相似试题
（单选题）
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）
（单选题）
For which database operation would you need the database to be in the MOUNT state（）
（多选题）
You are configuring a JMS server with a need for load balancing the messages. To achieve the load balance you should （）.
（多选题）
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）
（单选题）
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
（单选题）
You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application？（）
（单选题）
You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）
（单选题）
You include the calendar class in your Hotel Booking application. Which additional form level objects will you need to create to implement this reusable component fully?（）
（单选题）
You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）
（单选题）
You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）
