文件名称：1Z0-47试题详解
文件大小：453KB
文件格式：DOC
更新时间：2015-03-10 05:12:07
OCA 1Z0-47
1Z0-47试题详解。例如： 1. You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL. If a new customer has a credit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL. All new customer details have to be inserted into the CUST table. Which technique should be used to load the data most efficiently? A. external table B. the MERGE command C. the multitable INSERT command D. INSERT using WITH CHECK OPTION 答案: C 分析: 本题考点是multitable INSERT 题目要求将NEW_CUST表上所有的记录插入CUST表，credit limit大于10000的记录要同时插入CUST_SPECIAL表，应该使用有条件的insert命令，sql如下: insert all when credit_limit>=10000 into CUST_SPECIAL when 1=1 into CUST A. 外部表是只读的，不能进行插入操作 B. merge命令只能针对一张表进行插入或者修改操作，不能针对多张表进行插入操作 D. insert命令没有with check option选项，with check option选项是create view时使用的