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

试卷科目：考试

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

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

1.[单选题]Examinethedescriptionoftheproductstable

Namenull?Type

PROD_IDnotnullNUMBER

PROD_NAMEVARCHAR2(40)

COSTNUMBER(8,2)

RELEASE_DATEDATE

Whichqueryisvalid?

A)SELECTprodid,AVG(MAX(cost))FROMproductsGROUPBYprod_id

B)SELECTprodid,MAX(AVG(cost))FROMproductsGROUPBYprod_id

C)Selectprodid,releasedate,SUM(cost)FROMproductsGROUPBYprod_id

D)SELECTprodid,releasedate,SUM(cost)FROMproductsGROUPBYprodid,release_date

答案:D

解析:

2.[单选题]ExaminethedescriptionoftheSATES1table

NAMENULLTYPE

SALES_IDNOTNULLNUMBER

STORE_IDNOTNULLNUMBER

ITEMS_IDNUMBER

QUANTITYNUMBER

SALES_DATEDATE

SATES2isatablewiththesamedescriptionasSATES1，Somesalesdataiscontainederroneouslyinboth

tables，YoumustdisplayrowsfromSATES1andSATES2andwishtoseetheduplicatestoo,Whichset

operatorgeneratestherequiredoutput?

A)MINUS

B)UNIONALL

C)SUBTRACT

D)UNION

E)INTERSECT

答案:E

解析:

3.[单选题]ExaminethedescriptionoftheEMPLOYEEStable

NIS_DATEFORMATissettoDD-MON-YY

Whichqueryrequiresexplicitdatatypeconversion?

A)SELECTjoindateFROMemployeesWHEREjoindate10-02-2018;

B)SELECTjoindate||||salaryFROMemployees

C)SELECTsalary+120.50FROMemployees

D)SELECTSUBSTR(join_date,1,2)-10FROMemployees

E)SELECTjoindate+20FROMemployees

答案:A

解析:

4.[单选题]YourdatabaseinstanceisstartedwithanSPFILE

考试真题题1/2

试卷科目：考试

APFILEisalsoavailable

Youexecutethiscommand

ALTERSYSTEMSETDBCACHESIZE=100K

Whereisthevaluechanged?

A)intheSPFILEandPFTIE

B)intheSPFILE,PFILE,andmemory

C)onlyintheSPFILE

D)intheSPFILEandinmemory

E)onlyinmemory

答案:D

解析: