2011 Oracle OCP 1Z0-007题库：实战模拟与免费试用

需积分: 0 11 浏览量更新于2024-07-29 收藏 986KB PDF 举报

Oracle007题库是一个针对Oracle数据库认证考试的专业学习资源，特别针对的是Oracle 9i SQL部分，题库提供用于Oracle Certified Professional (OCP) 007考试的学习材料。这个题库强调其核心价值在于包含实际的考试题目，这些问题与真实考试的题型和难度保持一致。题目的答案都经过专家验证，并且包括详细的解释，确保学习者能够理解每个问题背后的原理。题库的特色是提供图形和拖放式展品，这有助于考生熟悉考试环境和界面，提高在实际考试中的操作技能。为了检验题库的质量，用户可以免费下载题库的四分之一部分，网址是http://www.certificationking.com。此外，该资源还提供了其他IT认证考试的完整版指南，如Microsoft（如70-270、70-305等）、Cisco（如642-901、642-871等）、Novell、Adobe、Apple、3COM、Citrix、CIW、EMC、Enterasys、ExamExpress、Foundry、Hyperion等多个品牌下的多个认证考试，满足不同考生的需求。购买者可以从这些免费资源开始学习，如果对质量满意，可以选择购买剩余部分以获取完整的题库内容。这种灵活的模式旨在帮助考生高效准备，确保他们在第一次尝试时就能通过考试，只需要大约10-12小时的学习时间。Oracle007题库是一个全面且实用的备考工具，对于想要考取Oracle数据库认证的人来说，是一个不可或缺的参考资料。

USING (e.employee_id = m.employee_id)

AND e.salary > 4000;

Answer: C

Q: 19 The EMPLOYEES table has these columns:

LAST_NAME VARCHAR2(35)

SALARY NUMBER(8,2)

HIRE_DATE DATE

Management wants to add a default value to the SALARY column. You plan to alter the table by using

this SQL statement:

ALTER TABLE EMPLOYEES

MODIFY (SALARY DEFAULT 5000);

Which is true about your ALTER statement?

A. Column definitions cannot be altered to add DEFAULT values.

B. A change to the DEFAULT value affects only subsequent insertions to the table.

C. Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

Answer: B

Q: 20 Examine the description of the CUSTOMERS table:

CUSTOMER_ID NUMBER(4) NOT NULL

CUSTOMER_NAME VARCHAR2(100) NOT NULL

STREET_ADDRESS VARCHAR2(150)

CITY_ADDRESS VARCHAR2(50)

STATE_ADDRESS VARCHAR2(50)

PROVINCE_ADDRESS VARCHAR2(50)

COUNTRY_ADDRESS VARCHAR2(50)

POSTAL_CODE VARCHAR2(12)

CUSTOMER_PHONE VARCHAR2(20)

The CUSTOMER_ID column is the primary key for the table.

Which statement returns the city address and the number of customers in the cities Los Angeles or San

Francisco?

www.CertificationKing.com

- 15 -

FROM EMP

WHERE DEPARTMENT_ID = NULL;

What is true about this SQL statement ?

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.

Answer: C

Q: 23 Which two statements about sequences are true? (Choose two.)

A. You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a

sequence, without actually retrieving the value.

B. You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without

affecting the further values to be generated from the sequence.

C. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually

retrieving the value from the sequence.

D. You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a

specified database column.

E. If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all

of these applications could have a value of 105 assigned to their column whose value is being generated by the

sequence.

F. You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum

value defined for the sequence.

Answer: B, C

Q: 24 What is true of using group functions on columns that contain NULL

values?

A. Group functions on columns ignore NULL values.

B. Group functions on columns returning dates include NULL values.

C. Group functions on columns returning numbers include NULL values.

D. Group functions on columns cannot be accurately used on columns that contain NULL values.

E. Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.

Answer: A

www.CertificationKing.com

- 18 -

剩余92页未读，继续阅读

小心小星

粉丝: 2
资源: 7

2011 Oracle OCP 1Z0-007题库：实战模拟与免费试用

Oracle 007 题库

Oracle-007题库

oracle 认证 007题库

Oracle数据库 OCP 007题库

Oracle 007 042 043题库

Oracle认证题库

oracle 升级题库

oracle上机题库

oracle考试题库

Oracle练习题库

最新资源