ocp考试 047 原题解析
5星 · 超过95%的资源 需积分: 10 9 浏览量
2013-03-12
16:36:50
上传
评论 4
收藏 453KB DOC 举报 
a
1Z0-047 51-100
1Z0-047 1-50
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时使用的
2. View the Exhibit and examine the description of the CUSTOMERS table. You want to
add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that
the value inserted in the column does not have numbers. Which SQL statement would
you use to accomplish the task?
A. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'^AZ')) NOVALIDATE;
B. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'^[09]')) NOVALIDATE;
C. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'[[:alpha:]]'))NOVALIDATE;
D. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'[[:digit:]]'))NOVALIDATE;
答案: C
分析: 本题考点是正则表达式/REGEXP
要在表CUSTOMERS的字段CUST_FIRST_NAME建个约束，使这个字段不能包含数字
A. 匹配开头是AZ的字符串。
B. 匹配开头是0或者是9的字符串。
C. 匹配包含字母的字符串。
D. 匹配包含数字的字符串。
3. Which three tasks can be performed using regular expression support in Oracle
剩余63页未读，继续阅读
- 1
- 2
- 3
前往页