146.Evaluate the following SQL statement:
来源:互联网 发布:linux 赋值 命令结果 编辑:程序博客网 时间:2024/05/23 19:59
146.Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name FROM customers
WHERE cust_credit_limit IN
(select cust_credit_limit FROM customers WHERE cust_city ='Singapore');
Which statement is true regarding the above query if one of the values generated by the subquery is NULL?
A.It produces an error.
B.It executes but returns no rows.
C.It generates output for NULL as well as the other values produced by the subquery.
D.It ignores the NULL value and generates output for the other values produced by the subquery.
答案:C
解析:这里选择C,in不会忽略null,如果是not in的话,会忽略null,oracle会将
not in(expr1)变成not in(expr1,null)
SQL> SELECT cust_id, cust_last_name FROM customers
WHERE cust_credit_limit IN
(select cust_credit_limit FROM customers WHERE cust_city ='Singapore');
Which statement is true regarding the above query if one of the values generated by the subquery is NULL?
A.It produces an error.
B.It executes but returns no rows.
C.It generates output for NULL as well as the other values produced by the subquery.
D.It ignores the NULL value and generates output for the other values produced by the subquery.
答案:C
解析:这里选择C,in不会忽略null,如果是not in的话,会忽略null,oracle会将
not in(expr1)变成not in(expr1,null)
0 0
- 146.Evaluate the following SQL statement:
- 155.Evaluate the following SQL statement
- 156.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?
- FPGA定时器的计数设置,是否要减1?(精密计数)
- IntelliJ-Idea工具的常用快捷键和在html里的常用快捷键
- 我的2015
- LEETCODE 125
- 630A. Again Twenty Five!
- 146.Evaluate the following SQL statement:
- IOS网络支持库AFNetworking(1)
- Spark的TaskScheduler和DagScheduler
- Jenkins + Git + fir 构建并分发 iOS 项目
- iOS 拖动手势
- Tomcat部署不到Web项目
- spring无法创建Bean
- Android editText 隐藏密码框
- 自写:二维码签到程序,功能咋能完善一些?