10gOCP题库(EXE+PDF)2012年1月刚过考试资源-CSDN文库

共7个文件

pdf：5个

exe：2个

5星 · 超过95%的资源需积分: 3 68 浏览量 2012-01-12 13:48:48 上传评论 4 收藏 20.84MB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

10g OCP 题库(EXE+PDF).rar （7个子文件）

10g OCP 题库(EXE+PDF)

1Z0-042题库.pdf 2.62MB

1Z0-043.exe 581KB

1Z0-042模拟器.exe 1.14MB

Oracle 10g OCP 047+042+043 题库清江石解析版

Oracle 10g OCP 042清江石解析版(175题).pdf 1.69MB

Oracle 10g OCP 047清江石解析版(精简版).pdf 14.5MB

Oracle 10g OCP 043 清江石解析版(185题).pdf 1.1MB

1Z0-043_217.pdf 272KB

QQ:54110058 清江石

声明：对于答案的相关的说明，是个人对 Oracle 的理解和收集相关资

料整理,供大家参考学习。

2011-08-02

说明: 127与196(已经删除)相同 108与234(已经删除)相同 91与205(已经删除)相同

125与264(已经删除)相同 13与255(已经删除)相同 43与156(已经删除)相同

72与216(已经删除)相同 1与251(已经删除)相同 83与269(已经删除)相同

6与220(已经删除)相同 135与178(已经删除)相同 64与258(已经删除)相同

114与217(已经删除)相同 107与237(已经删除)相同 65与219(已经删除)相同

98与140(已经删除)相同 113与213(已经删除)相同 136与227(已经删除)相同

46与148(已经删除)相同 97与209(已经删除)相同 116与181(已经删除)相同

99与156(已经删除)相同 28与248(已经删除)相同 100与143(已经删除)相同

56与222(已经删除)相同 94与239(已经删除)相同 103与154(已经删除)相同

76与191(已经删除)相同 110与277(已经删除)相同 112与179(已经删除)相同

132与270(已经删除)相同 70与179(已经删除)相同 92与157(已经删除)相同

130与275(已经删除)相同 35与273(已经删除)相同 104与241(已经删除)相同

24与246(已经删除)相同 158与126(已经删除)相同 87与204(已经删除)相同

109与149(已经删除)相同 58与236(已经删除)相同

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

Answer: C

1: 无条件 INSERT ALL

从 EMPLOYEES 中选择 EMPLOYEE_ID 大于200的雇员 EMPLOYEE_ID, HIRE_DATE, SALARY, 和

MANAGER_ID 值

用多表 INSERT 插入这些值到 SAL_HISTORY 和 MGR_HISTORY 表中

INSERT ALL

INTO sal_history VALUES(EMPID,HIREDATE,SAL)

INTO mgr_history VALUES(EMPID,MGR,SAL)

SELECT employee_id EMPID, hire_date HIREDATE,

salary SAL, manager_id MGR

FROM employees

WHERE employee_id > 200;

The example in the slide inserts rows into both the SAL_HISTORY and the MGR_HISTORY

tables.//插入到两个表中.

2: 条件INSERT ALL

从 EMPLOYEES 表中选择 EMPLOYEE_ID 大于200的那些雇员的 EMPLOYEE_ID, HIRE_DATE,

SALARY 和 MANAGER_ID 值

如果 SALARY 大于 $10,000，用一个条件多表 INSERT语句插入这些值到 SAL_HISTORY 表中

如果 MANAGER_ID 大于 200，用一个多表 INSERT 语句插入这些值到 MGR_HISTORY 表中

INSERT ALL

WHEN SAL > 10000 THEN

INTO sal_history VALUES(EMPID,HIREDATE,SAL)

WHEN MGR > 200 THEN

INTO mgr_history VALUES(EMPID,MGR,SAL)

SELECT employee_id EMPID,hire_date HIREDATE,

salary SAL, manager_id MGR

FROM employees

WHERE employee_id > 200;

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 thevalue 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,'^A-Z'))NOVALIDATE .

B. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name

CHECK(REGEXP_LIKE(cust_first_name,'^[0-9]'))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 .

Answer: C

Eg:

SELECT REGEXP_SUBSTR('123 Maple Avenue', '[A-Za-z]') ADDRESS FROM DUAL;

返回：M

SELECT REGEXP_SUBSTR('123 Maple Avenue', '[A-Za-z]+') ADDRESS FROM DUAL;

返回：Maple

SELECT REGEXP_SUBSTR('123 Maple Avenue', '[[:alpha:]]+') ADDRESS FROM DUAL;

返回：Maple

SELECT REGEXP_SUBSTR('123 Maple Avenue', '[:alpha:]+') ADDRESS FROM DUAL;

返回：apl

SELECT REGEXP_SUBSTR('123 Maple Avenue', '[[:alnum:]]+') ADDRESS FROM DUAL;

返回：123

SELECT REGEXP_SUBSTR('123 Maple Avenue', '[[:digit:]]+') ADDRESS FROM DUAL;

返回：123

3. Which three tasks can be performed using regular expression support in

Oracle Database 10g?

(Choose three.)

A. It can be used to concatenate two strings.

B. It can be used to find out the total length of the string.

C. It can be used for string manipulation and searching operations.

D. It can be used to format the output for a column or expression having string

data.

E. It can be used to find and replace operations for a column or expression

having string data.

Answer: CDE

Manipulation:操作 concatenate:连接

有REGEXP_SUBSTR,REGEXP_INSTR,REGEXP_REPLACE,REGEXP_LIKE

4. View the Exhibit and examine the structure of the EMP table which is not

partitioned and not an indexorganized table.

Evaluate the following SQL statement:

ALTER TABLE emp DROP COLUMN first_name.

Which two statements are true regarding the above command? (Choose two.)

A. The FIRST_NAME column would be dropped provided it does not contain any

data.

B.The FIRST_NAME column would be dropped provided at least one or more columns

remain in the table.

C. The FIRST_NAME column can be rolled back provided the SET UNUSED option

is added to the above SQL statement.

D. The FIRST_NAME column can be dropped even if it is part of a composite

PRIMARY KEY provided the CASCADE option is used.

Answer:B,D

5. Evaluate the CREATE TABLE statement:

CREATE TABLE products (product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY

KEY,product_name VARCHAR2(15)).

Which statement is true regarding the PROD_ID_PK constraint?

A. It would be created only if a unique index is manually created first.

B. It would be created and would use an automatically created unique index.

C. It would be created and would use an automatically created nonunique index.

D. It would be created and remains in a disabled state because no index is

specified in the command.

Answer: B

6. Which two statements are true? (Choose two.)

A. The USER_SYNONYMS view can provide information about private synonyms.

B. The user SYSTEM owns all the base tables and user-accessible views of the

data dictionary.

C. All the dynamic performance views prefixed with V$ are accessible to all

the database users.

D. The USER_OBJECTS view can provide information about the tables and views

created by the user only.

E. DICTIONARY is a view that contains the names of all the data dictionary

views that the user can access.

Answer: AE

Accessible:可达到,可访问 investigation:调查,研究

USER_SYNONYMS view, which only shows private synonyms.

The USER_OBJECTS view contains information about all objects owned by the

user.(d为什么不对?) ALL the objects created by the user can be found in view

USER_OBJECTS, not only tables and views.

DICTIONARY view is a great starting point for any investigation of the data

dictionary. If we DESCRIBE the view, we get the following:

Name Null Type

-------------- ---------------

TABLE_NAME VARCHAR2(30)

COMMENTS VARCHAR2(4000)

select * from dba_data_files 静态的来自数据文件

select * from v$datafile 动态的来自控制文件或内存

7. View the Exhibit and examine the description of the ORDERS table.

Which two WHERE clause conditions demonstrate the correct usage of conversion

functions? (Choose two.)

A. WHERE order_date > TO_DATE('JUL 10 2006','MON DD YYYY')

B. WHERE TO_CHAR(order_date,'MON DD YYYY') = 'JAN 20 2003'

C. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),'MON DD YYYY')

D. WHERE order_date IN ( TO_DATE('Oct 21 2003','Mon DD YYYY'), TO_CHAR('NOV

21 2003','Mon DD YYYY') )

Answer: AB

Demonstrate :证明 conversion:转化

order_date本身数据类型是timestamp型，需要转换成相同类型才能比较

Editor’s notes: conversion function 有 to_char,to_date ,to_number等

8. View the Exhibit and examine the description of the EMPLOYEES table.

Your company decided to give a monthly bonus of $50 to all the employees who

have completed five years in the company. The following statement is written

to display the LAST_NAME, DEPARTMENT_ID,and the total annual salary:

SELECT last_name, department_id, salary+50*12 "Annual Compensation"

FROM employees

WHERE MONTHS_BETWEEN(SYSDATE, hire_date)/12 >= 5.

When you execute the statement, the "Annual Compensation" is not computed

correctly. What changes would you make to the query to calculate the annual

compensation correctly?

评论收藏

内容反馈

韩量超标

2012-09-27

题库很好，本人已过，多谢lz!
shyhappyaa

2012-03-11

里面的考题解析非常详细！！我找了好久了，非常感谢您的分享！！！！
quartz031

2013-01-03

下了好几个题库，这个算是比较全的
o8xv0123

2013-05-29

有详细解析很不错的
leimingbuaa

2012-05-11

确实是比较新的，比较好，齐全，新，很有价值，认真看去了

前往

页

insov

粉丝: 0
资源: 4

10g OCP 题库(EXE+PDF) 2012年1月刚过考试

最新资源

10g OCP 题库(EXE+PDF) 2012年1月刚过考试

OCP10g_OCP考试题库EXE

OCP 10g 考试题库 042

OCP 10g考试题库 1Z0-047

Oracle_11g_OCP最新题库(PDF+VCE)2013.10.25考试过

oracle 10g OCP考试模拟器（含042，043，047题库）

2021年OCP考试题库.pdf

oracle 10g ocp 043题库

Oracle 11g OCP题库 O51 052 053 pdf版

OCP 10g 题库+模拟考试

ORACLE 10G OCP 题库

ocp_题库+模拟器.zip

ORACLE认证题库 OCA 10G 11G OCP 11G 题库

Oracle 10g OCP 题库

OCP053模拟器+题库

ocp题库ocp题库

OCP题库题库题库题库

ocp考试047题库

ocp最新11g升级题库（2011年10月） 1Z0-050和考试模拟器

Oracle+Database+10g+OCP+Certification+All-in-One+Exam+Guide

oracle10g OCP 题库

ocp11g复习题库及模拟考试软件

oci.dll 12版本全部

数据库系统概念（原书第七版）课后作业题

fineReport课后10题答案.zip

win64-11gR2-client.zip

Oracle19c-Windows客户端

oracle 12c windows 安装包下载

最新资源