Oracle 10g OCP题库精华：SQL实战与免费试下载

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

Oracle 10g 题库 007 是一个专注于Oracle 10g数据库认证考试的学习资源，特别针对Oracle Certified Professional (OCP) 10的考生提供题库支持。该题库主要包含实际考试中的问题，确保了考生在准备阶段能够接触到与真实考试几乎完全一致的考题。它不仅提供精选的156道SQL相关问题，而且这些问题都配有详尽的答案解析，这些答案和解释由IT专家验证过，确保准确性。题库的特点在于其丰富的图形和拖放式展示方式，这些元素在实际考试中也会出现，帮助考生熟悉真实的考试环境。为了保证质量，用户可以从官方网站www.certificationking.com免费下载题库的一部分进行试用，以便评估学习材料的实用性和有效性。此外，该资源还覆盖了其他知名厂商的认证考试，包括Microsoft（如70-270、70-305等）、Cisco（如642-901、642-502等）、Novell、Adobe、Apple、3COM、Citrix、CIW、EMC、Enterasys、ExamExpress、Foundry、Hyperion等，这表明它是一个综合性的备考工具，适合那些希望同时准备多个认证考试的考生。如果你对这些免费的指导感到满意，可以选择购买完整的Oracle 1Z0-007题库，以及其他认证考试的完整版本。通过这样的全面学习，考生可以大大增加通过OCP 10考试的信心，节省时间并提高通过率。 Oracle 10g 题库 007是一个高效且实用的IT认证考试准备资源，无论是对于初次接触Oracle 10g的考生还是经验丰富的专业人士，都能提供有价值的复习资料和实战模拟体验。

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页未读，继续阅读

amoycool

粉丝: 0
资源: 3

Oracle 10g OCP题库精华：SQL实战与免费试下载

oracle OCP认证题库 007,047,042,043 带个人注解翻译

ocp 052 题库

OCP题库题库题库题库

oracle 10g ocp考试题库 007

ocp 题库 007

ocp题库 007 042 043

ocp 10g007 考试题库

Oracle数据库 OCP 007题库

OCP10g_OCP考试题库EXE

10g OCP 043题库

最新资源