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(TRALINGsonFROMcust_last_name),An,O)FROMcustomers;

C)SELECTINITCAP(REPLACE(TRIM(sonFROMcust_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_date,6),1)FROMemployees;