OCP-1Z0-051-2015-29题
来源:互联网 发布:macbook如何删除软件 编辑:程序博客网 时间:2024/05/29 19:20
View the Exhibit and examine the structure of the CUSTOMERS table.
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY
that have the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:
INSERT INTO new_customers(cust_id,cust_name,cust_city)
values(select cust_id,cust_first_name||' '||cust_last_name,cust_name from customers where cust_id>23004);
The INSERT statement fails when executed. What could be the reason?
A. The VALUES clause cannot be used in an INSERT with a subquery
B. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table列数对不上
C. The WHERE clause cannot be used in a sub query embedded嵌入 in an INSERT statement
D. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match列名在两表中不符合。
Answer: A
Explanation:
Copying Rows from Another Table Write your INSERT statement with a subquery:
Do not use the VALUES clause.values后面不能跟子查询,或者直接不要VALUES 。不然会报错:
Match the number of columns in the INSERT clause to those in the subquery.
Inserts all the rows returned by the subquery in the table, sales_reps.
- OCP-1Z0-051-2015-29题
- OCP-1Z0-051-2015-1题
- OCP-1Z0-051-2015-2题
- OCP-1Z0-051-2015-3题
- OCP-1Z0-051-2015-4题
- OCP-1Z0-051-2015-5题
- OCP-1Z0-051-2015-6题
- OCP-1Z0-051-2015-7题
- OCP-1Z0-051-2015-8题
- OCP-1Z0-051-2015-9题
- OCP-1Z0-051-2015-10题
- OCP-1Z0-051-2015-11题
- OCP-1Z0-051-2015-12题
- OCP-1Z0-051-2015-13题
- OCP-1Z0-051-2015-14题
- OCP-1Z0-051-2015-15题
- OCP-1Z0-051-2015-16题
- OCP-1Z0-051-2015-17题
- Android GPS学习笔记—LMS初始化
- Android消息推送
- 织梦列表和分页的调用
- 表哥布局
- 对于Fragment的一点认知
- OCP-1Z0-051-2015-29题
- java.lang.IllegalStateException异常产生的原因及解决办法
- 【伯猫Java教程】网页游戏开发过程——Java与Flex的通信过程
- 如何让mysql数据库支持超大图片
- STL复习
- (7.2.5.2)如何通过加密保护SQL Server敏感数据
- MongoDB的文档增删改
- QWT编译、配置、使用(VS2010 + Qt5.1.0)
- DG基础知识