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
相关问题推荐
-
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()
A、Data files that belong to only the root container
B、Data files that belong to the root container and all the pluggable databases (PDBs)
C、Data files that belong to only the root container and PDB$SEED
D、Data files that belong to the root container and all the PDBs excluding PDB$SEED
-
心肺复苏中最关键的步骤是()
A、心脏按压
B、心内注射
C、心前区叩击
D、清理呼吸道
E、口对口人工呼吸
-
胃十二指肠溃疡上腹部疼痛可表现为()
A、节律性上腹痛
B、转移性疼痛
C、上腹饱胀
D、压榨性痛
E、上腹部疼痛伴窒息感
-
管理二重性的体现()
A、管理的科学性
B、管理的自然属性
C、管理的广泛性
D、人和时间
E、能源和信息
-
TD-LTE系统竞争随机接入过程应用场景包括()。
A、IDLE态初始接入
B、RRC连接重建
C、上行数据到达
D、下行数据到达
E、切换
F、定位