156.Evaluate the following SQL statement:
来源:互联网 发布:菲尼克斯之光 知乎 编辑:程序博客网 时间:2024/05/29 06:59
156.Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30;
Which ORDER BY clauses are valid for the above query? (Choose all that apply.)
A.ORDER BY 2,1
B.ORDER BY CUST_NO
C.ORDER BY 2,cust_id
D.ORDER BY "CUST_NO"
E.ORDER BY "Last Name"
答案:ACE
解析:union 合并的时候是按照第一条sql语句列走的
A:正确,通过占位符号走的,与列别名没有关系
B:错误,第一条sql没有cust_no
C:正确,2是占位符号,cust_id第一条也存在
D:错误,和B一样
E:正确:第一条sql存在Last Name
SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30;
Which ORDER BY clauses are valid for the above query? (Choose all that apply.)
A.ORDER BY 2,1
B.ORDER BY CUST_NO
C.ORDER BY 2,cust_id
D.ORDER BY "CUST_NO"
E.ORDER BY "Last Name"
答案:ACE
解析:union 合并的时候是按照第一条sql语句列走的
A:正确,通过占位符号走的,与列别名没有关系
B:错误,第一条sql没有cust_no
C:正确,2是占位符号,cust_id第一条也存在
D:错误,和B一样
E:正确:第一条sql存在Last Name
0 0
- 156.Evaluate the following SQL statement:
- 146.Evaluate the following SQL statement:
- 155.Evaluate the following SQL statement
- 43.Evaluate the following CREATE SEQUENCE statement:
- 167.Evaluate the following DELETE statement:
- ocp 047-141 Evaluate the following SQL statement:SELECT product_name || 'it's not available for orde
- 31.Evaluate the following SQL commands:
- 19.Evaluate the following query:
- 78.Evaluate the following query:
- 30.Evaluate the following CREATE TABLE commands:
- 55.Evaluate the following two queries:
- 55.Evaluate the following two queries:
- 16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date A
- 36.Examine the following SQL commands:
- 10.Examine the following statement that is used to modify the constraint on the SALES table:
- ocp 047-92 Evaluate the following expression using meta. character for regular expression:'[^Ale|ax
- 39.Evaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY
- Which of the following statement(s) equal(s) value 1 in C programming language?
- iOS添加字体汇总
- Java Web开发5___jQuery 中 按钮点击事件的几种写法
- 2016.03.14
- Delphi数据类型
- (十一)boost库之多线程间通信
- 156.Evaluate the following SQL statement:
- 常用文件存储方法参考
- 2705: [SDOI2012]Longge的问题|欧拉函数
- 跟我一起学Microsoft SQL Server 2012 Internals(2.1)
- Valgrind使用说明
- ADT的配置
- Android开发笔记(八十)运行状态检查
- css设置当前鼠标样式
- 《Effctive C++》读书笔记--(02)Prefer consts,enums,and inlines to #defines