OracleOCP认证考试练习真题题库十.pdfVIP

试卷科目：考试

OracleOCP认证考试练习真题题库十

第1部分：单项选择题，共77题，每题只有一个正确答案,多选或少选均不得分。

1.[单选题]Choosethebestanswer.

ExaminethedescriptionoftheEMPLOYEEStable:

NameNullType

EMP_IDNOTNULNUMBER

EMP_NAMEVARCHAR2(40)

DEPT_IDNUMBER(2)

SALARYNUMBER(8,2)

JOIN_DATEDATE

Whichqueryisvalid?

A)SELECTdept_id,join_date,SUM(salary)FROMemployeesGROUPBYdept_id,join_date;

B)SELECTdepe_id,join_date,SUM(salary)FROMemployeesGROUPBYdept_id:

C)SELECTdept_id,MAX(AVG(salary))FROMemployeesGROUPBYdept_id;

D)SELECTdept_id,AVG(MAX(salary))FROMemployeesGROUPBYdapt_id;

答案:A

解析:

2.[单选题]Choosethebestanswer

TheCUSTOMERStablehasaCUST_LAST_NAMEcolumnofdatatypeVARCHAR2.Thetablehastworowswhose

COST_LAST_MANEvaluesareAndersonandAusson.

WhichqueryproducesoutputforCUST_LAST_SAMEcontainingOderforthefirstrowandAusforthesecond?

A)SELECTREPLACE(REPLACE(cust_last_name,'son',''),'An','O')FROMcustomers;

B)SELECTREPLACE(TRIM(TRALING'son'FROMcust_last_name),'An','O')FROMcustomers;

C)SELECTINITCAP(REPLACE(TRIM('son'FROMcust_last_name),'An','O'))FROMcustomers;

D)SELECTREPLACE(SUBSTR(cust_last_name,-3),'An','O')FROMcustomers;

答案:A

解析:trim只能处理过滤掉一个字符,不能过滤多个字符,所以BC可以排除。

3.[单选题]Choosethebestanswer

TheEMPLOYEEStablecontainscolumnsEMP_IDofdatatypeNUMBERandHIRE_DATEofdatatypeDATE

YouwanttodisplaythedateofthefirstMondayafterthecompletionofsixmonthssincehiring

TheNLS_TERRITORYparameterissettoAMERICAinthesessionand,therefore,Sundayisthefirstdayof

theweek

Whichquerycanbeused?

A)SELECTemp_id,NEXT_DAY(ADD_MONTHS(hite_date,6),'MONDAY')FROMemployees;

B)SELECTemp_id,ADD_MONTHS(hire_date,6),NEXT_DAY('MONDAY')FROMemployees;

C)SELECTemp_id,NEXT_DAY(MONTHS_BETWEEN(hire_date,SYSDATE),6)FROMemployees;

D)SELECTemp_id,NEXT_DAY(ADD_MONTHS(hire