brain0728的专栏

OCP-043解析考点解析，详细的解答，有助于你的考前复习。

详细的考点解答，考前复习使用效果很好，只要认真看。

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时使用的

PDF 2 DOC工具，转换PDF 到 DOC格式

OCA 047 word版，方便添加注释