没有合适的资源？快使用搜索试试~ 我知道了~

文库首页数据库OracleOCP 考试 007 资料

OCP 考试 007 资料

oracle

需积分: 3 1 下载量 63 浏览量 2011-03-08 09:09:25 上传评论收藏 1.56MB PDF 举报

温馨提示

试读

93页

考试的时候题目是一摸一样的，完全一样，我考了100分

资源推荐

资源详情

资源评论

Oracle 1Z0-007

Introduction to Oracle9i: SQL

156 Q&A

Looking for Real Exam Questions for IT Certification Exams!

We guarantee you can pass any IT certification exam at your first attempt with just 10-12

hours study of our guides.

Our study guides contain actual exam questions, you will get word to word same on your

actual test; accurate answers with detailed explanation verified by experts and all graphics

and drag-n-drop exhibits shown just as on the real test.

To test the quality of our guides, you can download the one-fourth portion of any guide from

http://www.certificationking.com absolutely free.

Besides, we also offer complete version of following exams absolutely free. You can start

your certification from these free guides and if you are satisfied you can buy the rest

♦ Microsoft: 70-270, 70-305, 70-526, MB2-421

♦ Cisco 642-901, 642-871, 642-611, 642-502, 642-425, 646-561

♦ Oracle: 1Z0-001, 1Z0-007, 1Z0-040, 1Z0-200 ♦ Novell: 50-676, 50-565

♦ Adobe: 9A0-019 ♦ Apple: 9L0-004, 9L0-505, 9L0-606 ♦ 3COM: 3M0-211

♦ Citrix: 1Y0-223, 1Y0-256 ♦ CIW: 1D0-420 ♦ EMC: E20-001 ♦ Enterasys: 2B0-011

♦ Exam Express: EE0-011 ♦ Foundry: FN0-100 ♦ Hyperion: 4H0-002

♦ HP: HP0-045, HP0-052, HP0-055, HP0-090, HP0-216, HP0-417

♦ Juniper: JN0-120, JN0-330 ♦ Lotus: 190-510 ♦ Network Appliances: NS0-121

♦ Network General: 1T6-520 ♦ Nortel: 920-430, 920-803 ♦ OMG: UM0-100

♦ Sybase: 510-015 ♦ SAIR: 3X0-101, 201 ♦ SAS: A00-201 ♦ Tibco: TB0-103 …..

For pricing and placing order, please visit http://certificationking.com/order.html

We accept all major credit cards through www.paypal.com

For other payment options and any further query, feel free to mail us at

info@certificationking.com

Q: 1 Examine the structure of the EMPLOYEES table:

EMPLOYEE_ID NUMBER Primary Key

FIRST_NAME VARCHAR2(25)

LAST_NAME VARCHAR2(25)

Which three statements insert a row into the table? (Choose three.)

A. INSERT INTO employees

VALUES ( NULL, 'John', 'Smith');

B. INSERT INTO employees( first_name, last_name)

VALUES( 'John', 'Smith');

C. INSERT INTO employees

VALUES ( '1000', 'John', NULL);

D. INSERT INTO employees (first_name, last_name, employee_id)

VALUES ( 1000, 'John', 'Smith');

E. INSERT INTO employees (employee_id)

VALUES (1000);

F. INSERT INTO employees (employee_id, first_name, last_name)

VALUES ( 1000, 'John', ' ');

Answer: C, E, F

Q: 2 Evaluate the SQL statement:

SELECT ROUND(45.953, -1), TRUNC(45.936, 2)

FROM dual;

Which values are displayed?

A. 46 and 45

B. 46 and 45.93

C. 50 and 45.93

D. 50 and 45.9

E. 45 and 45.93

F. 45.95 and 45.93

Answer: C

www.CertificationKing.com

- 3 -

Q: 3 Which are DML statements? (Choose all that apply.)

A. COMMIT

B. MERGE

C. UPDATE

D. DELETE

E. CREATE

F. DROP...

Answer: B, C, D

Q: 4 Evaluate the set of SQL statements:

CREATE TABLE dept

(deptno NUMBER(2),

dname VARCHAR2(14),

loc VARCHAR2(13));

ROLLBACK;

DESCRIBE DEPT

What is true about the set?

A. The DESCRIBE DEPT statement displays the structure of the DEPT table.

B. The ROLLBACK statement frees the storage space occupied by the DEPT table.

C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT

statement introduced before the ROLLBACK statement.

Answer: A

Q: 5 Evaluate this SQL statement:

SELECT ename, sal, 12*sal+100

FROM emp;

The SAL column stores the monthly salary of the employee. Which change must be made to the above

syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied

by 12"?

A. No change is required to achieve the desired results.

www.CertificationKing.com

- 4 -

B. SELECT ename, sal, 12*(sal+100)

FROM emp;

C. SELECT ename, sal, (12*sal)+100

FROM emp;

D. SELECT ename, sal+100,*12

FROM emp;

Answer: B

Q: 6 Examine the SQL statement that creates ORDERS table:

CREATE TABLE orders

(SER_NO NUMBER UNIQUE,

ORDER_ID NUMBER,

ORDER_DATE DATE NOT NULL,

STATUS VARCHAR2(10)

CHECK (status IN ('CREDIT', 'CASH')),

PROD_ID NUMBER

REFERENCES PRODUCTS(PRODUCT_ID),

ORD_TOTAL NUMBER,

PRIMARY KEY (order_id, order_date));

For which columns would an index be automatically created when you execute the above SQL statement?

(Choose two.)

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. composite index on ORDER_ID and ORDER_DATE

Answer: A, F

Q: 7 Examine the structure of the EMP_DEPT_VU view:

Column Name Type Remarks

EMPLOYEE_ID NUMBER From the EMPLOYEES table

EMP_NAME VARCHAR2(30) From the EMPLOYEES table

JOB_ID VARCHAR2(20) From the EMPLOYEES table

SALARY NUMBER From the EMPLOYEES table

DEPARTMENT_ID NUMBER From the DEPARTMENTS table

DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table

www.CertificationKing.com

- 5 -

剩余92页未读，继续阅读

评论收藏

内容反馈

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

dabendan2009

粉丝: 0
资源: 1

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

OCP 考试 007 资料

OCP 考试资料

OCP考试资料

OCP考试资料合集

ocp考试内部资料

Oracle OCP 考试模拟器

OCP考试资料-OCP-19c-083.docx

OCP考试答题机

oracle ocp考试模拟器

oracle资料 关于OCP考试题目

OCP考试007试题

Oracle OCP 认证 007，042，043 考试复习题

OCP认证考试资料 1Z0-052 q209.pdf

OCP考试环境.zip

oracle考试，ocp考试及笔记

OCP考试模拟器

Oracle OCA OCP 认证007模拟考试软件

ocp考试047题库及模拟考试软件

Oracle 10g OCP考试相关资料

MySQL5.6 OCP考试资料.zip

OCP认证考试资料 1z-047.pdf

OCP考试资料-OCP-19c-082.docx

oracle-OCP考试学习资料(全).rar （PDF 英文版本） ORACLE 11G

ocp 10g007 考试题库

ocp考试资料合集

2021年OCP考试题库.pdf

OCP考试最新题库

OCP_题库&考试模拟器

最新资源

oracle资料关于OCP考试题目