Oracle OCP 1Z0-082-CHN认证考试题库（附答案）

PAGEPAGE1OracleOCP1Z0-082-CHN认证考试题库（附答案）一、单选题1.YourdatabaseinstanceisstartedwithanSPFILEAPFILEisalsoavailableYouexecutethismand

ALTERSYSTEMSETDBCACHESIZE=100K

Whereisthevaluechanged?A、intheSPFILEandPFTIEB、intheSPFILE,PFILE,andmemoryC、onlyintheSPFILED、intheSPFILEandinmemoryE、onlyinmemory答案：D2.Adatabaseisconfiguredtouseautomaticundomanagementwithtemporaryundoenabled.

AnUPDATEisexecutedonatemporarytable.

WhereistheUNDOstoted?A、intheSGAB、inthePGAC、intheSYSAUXtablespaceD、intheundotablespaceE、inthetemporarytablespace答案：E3.chooseoneExaminetheparametersforadatabaseinstance:NAMETYPEVALUEtemp_undo_enabledbooleanTRUEundo_managementstringAUTOundo_retentionInteger900undo_tablespacestringUNDOTBS1Yourdatabasehasthreeundotablespacesandthedefaultundotablespaceisnotautoextensible.

Resumablespaceallocationisnotenabledforanysessionsinthedatabaseinstance.

Whatistheeffectonnewtransactionswhenallundospaceinthedefaultundotablespaceisinusebyactivetransactions?A、TransactionswaituntilspacebeesavailableinUNDOTBS1.B、Transactionswritetheirundoinatemporarytablespace.C、Transactionsfail.D、TransactionswritetheirundointheSYSTEMundosegment.答案：C4.Youwanttoreducefragmentationandreclaimunusedspaceforthesalestablebutnotitsdependentobjects.Duringthisoperation,youwanttoensurethefollowing:

I.Long-runningqueriesarenotaffected.

Ii.Noextraspaceisused.

Iii.Datamanipulationlanguage(DML)operationsonthetablesucceedatalltimesthroughouttheprocessiv.Unusedspaceisreclaimedbothaboveandbelowthehighwatermark.

WhichalterTABLEoptionwouldyouremend?

您希望为sales表(而不是其依赖对象)减少碎片并回收未使用的空间。在此操作过程中,您要确保:

我长时间运行的查询不受影响。

二、没有额外的空间被使用。

Iii.在整个过程中,表上的数据操作语言(DML)操作始终成功iv.在高水位线上方和下方回收未使用的空间。

您会推荐哪种alterTABLE选项?

A)取消分配未使用的

B)收缩空间级联

C)压缩空间

D)行存储压缩基A、DEALLOCATEUNUSEDB、SHRINKSPACECASCADEC、SHRINKSPACEPACTD、ROWSTOREPRESSBASIC答案：C5.EvaluatethefollowingALTERTABLEstatement:

ALTERTABLEordersSETUNUSED(order_datE.;

Whichstatementistrue?A、AfterexecutingtheALTERTABLEmand,youcanaddanewcolumncalledORDER_DATEtotheORDERStable.B、TheORDER_DATEcolumnshouldbeemptyfortheALTERTABLEmandtoexecutesuccsessfully.C、ROLLBACKcanbeusedtogetbacktheORDER_DATEcolumnintheORDERStable.D、TheDESCRIBEmandwouldstilldisplaytheORDER_DATEcolumn.答案：A6.Examinethefollowingmand;

ALTERSYSTEMSETenable_ddl_logging=TRUE;

Whichstatementistrue?A、Onlythedatadefinitionlanguage(DDL)mandsthatresultedinerrorsareloggedinthealertlogfile.B、AllDDLmandsareloggedinthealertlogfile.C、AllDDLmandsareloggedinadifferentlogfilethatcontainsDDLstatementsandtheirexecutiondates.D、OnlyDDLmandsthatresultedinthecreationofnewsegmentsarelogged.E、AllDDLmandsareloggedinXMLformatinthealertdirectoryundertheAutomaticDiagnosticRepository(ADR)home.答案：C7.Inoneofyourdatabases,theuserHRhasthepasswordHRMGR.

Youwanttoconnecttoadatabaseinstancewhoselistenerlistensonport1531byusingthisstatement:

CONNECTHR/HRMGRorclNonameserverisused.

WhichstatementistrueaboutORCL?A、ItmustbethevalueoftheSERVICE_NAMESparameterontheclientsideB、Itmustresolvetoavalidconnectdescriptorintheserver’stnsnames.orafileC、Itmustresolvetoavalidconnectdescriptorintheclient’stnsnames.orafileD、ItmustbethenameofthedatabasetowhoseinstanceHRwishestoconnectE、ItmustbethenameoftheserverrunningthedatabasetowhoseinstanceHRwishestoconnect答案：C8.ExaminethedescriptionoftheEMPLOYEEStableNISDATEFORMATissettoDD-MON–YY.

Whichqueryrequiresexplicitdatatypeconversion?A、SELECTjoindateFROMemployeesWHEREjoindate>'10-02-2018';B、SELECTjoindate||''||salaryFROMemployeesC、SELECTsalary+'120.50'FROMemployeesD、SELECTSUBSTR(join_date,1,2)-10FROMemployeesE、SELECTjoindate+'20'FROMemployees答案：A9.Whatistrueaboutnon-equijoinstatementperformance?A、TheOraclejoinsyntaxperformslesswellthantheSQI:1999pliantANSIjoinsyntax.B、TheBETWEENconditionusedwithannon-equijoinalwaysperformsbetterthanwhenusingthe>=and<=conditions.

与非等连接一起使用的BETWEEN条件总是比使用>=和<=条件时表现更好。--这个说法上有歧义always往往代表一直总是但是不可能一成不变会随着表或者连接条件包括函数的使用产生不同的性能影响C、TheBETWEENconditionusedwithannon-equijoinsometimesperformsbetterthanusingthe>=and<=conditions.

与非等连接一起使用的BETWEEN条件有时比使用>=和<=条件表现更好。--这个是对的要看语句具体状况D、Thejoinsyntaxusedmakesnodifferencetoperformance.

使用的连接语法对性能没有影响。连接语法对性能一定有影响E、TheOraclejoinsyntaxperformsbetterthantheSQL:1999pliantANSIjoinsyntax.

Oraclejoin语法的性能优于符合SQL:1999的ANSI连接语法。不是最优解因为JOIN往往是等值连接答案：C10.Examinethismandandsomepartialoutput:WhydoestheDB01.abc.serviceshowunknownstatus?A、TheserviceDB01.abc.isdynamicallyregisteredB、TheLOCAL_LISTENERdatabaseparameterisnotsettoaservicenamethatreferstoLISTENER_1C、TheserviceDB01.abc.isstaticallyregisteredD、Thelistenerisnotlisteningonthedefaultport1521E、TheSID_LIST_LISTENERsectionisnotcontainedintheLISTENER.ORAfile答案：C11.ExaminethedescriptionoftheCUSTOMERStable:YouwanttodisplaydetailsofallcustomerswhoresideincitiesstartingwiththeletterDfollowedbyatleasttwocharacters.Whichquerycanbeused?A、SELECT*FROMcustomersWHEREcityLIKE‘D_%’;B、SELECT*FROMcustomersWHEREcity=‘%D_’;C、SELECT*FROMcustomersWHEREcityLIKE‘D_’;D、SELECT*FROMcustomersWHEREcity=‘D_%’;答案：A12.Whichstatementistrueaboutaggregatefunctions?A、AggregatefunctionscanbenestedtoanynumberoflevelsB、TheAVGfunctionimplicitlyconvertsNULLStozeroC、AggregatefunctionscanbeusedinanyclauseofaSELECTstatementD、TheMAXandMINfunctionscanbeusedoncolumnswithcharacterdatatypes答案：D13.Examinethedescriptionoftheproductstable

A、SELECTprodid,AVG(MAX(cost))FROMproductsGROUPBYprod.B、SELECTprodid,MAX(AVG(cost))FROMproductsGROUPBYprodidC、Selectprodid,releasedate,SUM(cost)FROMproductsGROUPBYprodidD、SELECTprodid,releasedate,SUM(cost)FROMproductsGROUPBYprodid,releasedate答案：D14.ExaminethedescriptionoftheEMPLOYEEStable:Whichqueryisvalid?A、SELECTdept_id,AVG(MAX(salary))FROMemployeesGROUPBYdept_id;B、SELECTdept_id,join_date,SUM(salary)FROMemployeesGROUPBYdept_id;C、SELECTdept_id,join_date,SUM(salary)FROMemployeesGROUPBYdept_id,join_date;D、SELECTdept_id,MAX(AVG(salary))FROMemployeesGROUPBYdept_id;答案：C15.IntheSALESdatabase,DEFERRED_SEGMENT_CREATIONisTRUE.Examinethismand:SQL>CREATETABLET1(c1INTPRIMARYKEY,c2CLOB.;

Whichsegmentorsegments,ifany,arecreatedasaresultofexecutingthemand?A、T1,anindexsegmentfortheprimarykey,aLOBsegment,andalobindexsegmentB、nosegmentsarecreated--T1开头排除掉C、T1onlyD、T1andanindexsegmentcreatedfortheprimarykeyonlyE、T1,anindexsegmentfortheprimarykey,andaLOBsegmentonly答案：B16.Choosethebestanswer.WhywouldyouusetheTNSPINGhrmand[W1]?A、toverify(验证)ifarequestedserviceisavailableB、todetermine(保证确定)ifthelistenerfortheHRnetservicenamecanbereachedC、toverifyiftheHRdatabaseinstanceisupD、tocheckandlistmultipleORACLE_HOMElocationsontheserverE、tovalidate(验证证实)thenetworkconnectivitybetweenaclientandthedatabaseinstance答案：B17.WhichpressionmethodisremendedforDirect-PathInsertoperations?A、COLUMNSTOREPRESSADVANCEDB、ROWSTOREPRESSADVANCEDC、COLUMNSTOREPRESSBASICD、ROWSTOREPRESSBASIC答案：B18.ExaminethedescriptionofthePROMOTIONStable:Managementrequiresareportofuniquepromotioncostsineachpromotioncategory.

Whichquerywouldsatisfythisrequirement?A、SELECTDISTINCTpromo_category,promo_costFROMpromotionsORDERBY1B、SELECTpromo_category,DISTINCTpromo_costFROMpromotionsC、SELECTDISTINCTpromo_cost,promo_categoryFROMpromotionsD、SELECTDISTINCTpromo_cost,DISTINCTpromo_categoryFROMpromotions;答案：A19.ViewtheExhibitsandexaminethestructureofthecostsandPROMOTIONStablesYouwanttodisplayPRODIDSwhosepromotioncostislessthanthehighestcostPRODIDinapromotiontimeinterval

Whatwillbetheresult?

A、Itexecutessuccessfullyandgivestherequiredresult.B、ItgivesanerrorbecausetheGROUPBYclauseisnotvalidC、ItexecutessuccessfullybutdoesnotgivetherequiredresultD、ItgivesanerrorbecausetheALLkeywordisnotvalid答案：A20.Yourdatabaseinstanceisstartedbyusingaserverparameterfile(SPFILE..

YouexecutethefollowingmandtochangethevalueoftheLOG_BUFFERinitializationparameter:ALTERSYSTEMSETLOG_BUFFER=32M;

Whatistheouteofthismand?

数据库实例是使用服务器参数文件(SPFILE)启动的。

您可以执行以下命令来更改LOG_BUFFER初始化参数的值:ALTERSYSTEMSETLOG_BUFFER=32M;

这个命令的结果是什么?A、TheparametervalueischangedanditesintoeffectassoonasspacebeesavailableintheSGA.B、Theparametervalueischangedanditesintoeffectatthenextinstancestartup.C、ItreturnsanerrorbecauseSCOPEshouldbesettoMEMORY.D、Itreturnsanerrorbecausethevalueofthisparametercannotbechangeddynamically.答案：D21.IntheORCLdatabase,UNDOTBS1istheactiveundotablespacewiththeseproperties:

1Asizeof100MB

2AUTOEXTENDisoff

3UNDO_RETENTIONissetto15minutes

4IthasRETENTIONGUARANTEEUNDOTBS1fillswithunmittedundo10minutesafterthedatabaseopens.

Whatwillhappenwhenthenextupdateisattemptedbyanytransaction?A、ItsucceedsandthegeneratedundoisstoredinSYSTEM.B、Itfailsandreturnstheerrormessage“ORA-30036:unabletoextendsegmentby8inundotablespace‘UNDOTBS1’“.C、ItsucceedsandtheleastrecentlywrittenundoblockofUNDOTBS1isoverwrittenbythegeneratedundo.D、ItsucceedsandthegeneratedundoisstoredinSYSAUX.E、ItsucceedsandtheleastrecentlyreadundoblockofUNDOTBS1isoverwrittenbythegeneratedundo.答案：B22.YouplantocreateadatabasebyusingtheDatabaseConfigurationAssistant(DBCA.,withthefollowingspecifications:Applicationswillconnecttothedatabaseviaamiddletier.Thenumberofconcurrentuserconnectionswillbehigh.Thedatabasewillhavemixedworkload,withtheexecutionofplexBIqueriesscheduledatnight.WhichDBCAoptionmustyouchoosetocreatethedatabase?A、aGeneralPurposedatabasetemplatewithdefaultmemoryallocationB、aDataWarehousedatabasetemplate,withthededicatedservermodeoptionandAMMenabledC、aGeneralPurposedatabasetemplate,withthesharedservermodeoptionandAutomaticMemoryManagement(AMM)enabledD、adefaultdatabaseconfiguration答案：C23.ExaminethedescriptionoftheSATES1table

SALES2isatablewiththesamedescriptionasSATES1Somesalesdataiscontainederroneouslyinbothtables

YoumustdisplayrowsfromsAlEs1andSALESandwishtoseetheduplicatestooWhichsetoperatorgeneratestherequiredoutput?A、MINUSB、UNIONALLC、SUBTRACTD、UNIONE、INTERSECT答案：B24.WhichstatementistrueregardingtheINTERSECToperator?

关于INTERSECT运算符,哪个语句是正确的?A、ThenamesofcolumnsinallSELECTstatementsmustbeidentical.B、ItignoresNULLvalues.C、Reversingtheorderoftheintersectedtablesalterstheresult.D、ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequery.答案：D25.Choosethebestanswer.Examinethesemands:

CONNECT/ASSYSDBA

SQL>CREATEDIRECTORYdumpdirAS‘/u01/app’;

Directorycreated.

SQL>GRANTREAD,WRITEONDIRECTORYdumpdirTOPUBLIC;

Grantsucceeded.

SQL>GRANTUSERTESTIDENTIFIEDBYtest;

Usercreated.

SQL>GRANTCREATESESSION,RESOURCE,UNLIMITEDTABLESPACETOtest;

Grantsucceeded.

SQL>CONNtest/test.

Connected.

SQL>CREATETABLEtest_employees(idNUMBER(3),nameVARCHAR2(20),salaryNUMBER(7));

Tablecreated.

SQL>CREATESYNONYMempFORtest_employees;

Synonymcreate.

Nowexaminethismand:$expdptest/testDIRECTORY=dumpdirDUMPFILE=test_emp.dmpLOGFILE=test.logTABLES=emp

Whichistrue?A、Itperformstheexportsuccessfully.B、Itthrowsanerrorasthetabletest_employeesisemptyandCONTENT=data_onlyisspecified.C、ItthrowsanerrorastheQUERYparameterisnotsupportedonanemptytable.D、ItthrowsanerrorasDataPumpcannotfindatablecalledTEST.EMP.答案：D26.WhichstatementistrueabouttheINTERSECToperatorusedinpoundqueries?A、MultipleINTERSECToperatorsarenotpossibleinthesameSQLstatementB、ItprocessesNULLsintheselectedcolumnsC、INTERSECTisoflowerprecedencethanUNIONorUNIONALLD、ItignoresNULLs答案：B27.Youhavebeentaskedtocreateatableforabankingapplication.Oneofthecolumnsmustmeetthreerequirements:BestoredinaformatsupportingdatearithmeticwithoutusingconversionfunctionsStorealoanperiodofupto10yearsBeusedforcalculatinginterestforthenumberofdaystheloanremainsunpaidWhichdatatypeshouldyouuse?A、INTERVALYEARTOMONTHB、INTERVALDAYTOSECONDC、TIMESTAMPWITHLOCALTIMEZONED、TIMESTAMPE、TIMESTAMPWITHTIMEZONE答案：B28.ViewtheExhibitandexaminethestructureoftheCUSTOMERStable.

UsingtheCUSTOMERStable,youmustgenerateareportthatdisplaysacreditlimitincreaseof15%forallcustomers.

Customerswithnocreditlimitshouldhave“NotAvailable”displayed.

WhichSQLstatementwouldproducetherequiredresult?A、SELECTNVL(TO_CHAR(cust_credit_limit*.15),‘NotAvailable’)“NEWCREDIT”FROMcustomersB、SELECTTO_CHAR(NVL(cust_credit_limit*.15),‘NotAvailable’))“NEWCREDIT”FROMcustomersC、SELECTNVL(cust_credit_limit*.15,‘NotAvailable’)“NEWCREDIT”FROMcustomersD、SELECTNVL(cust_credit_limit,‘NotAvailable’)*.15“NEWCREDIT”FROMcustomers答案：A29.choosethebestanswerEvaluatethefollowingSQLstatement:

ALTERTABLEhr.empSETUNUSED(mgr_iD.;

WhichstatementistrueregardingtheeffectoftheaboveSQLstatement?A、AnyviewscreatedontheEMPtablethatincludetheMGR_IDcolumnwouldbeautomaticallymodifiedandremainvalid.B、AnyconstraintsdefinedontheMGR_IDcolumnwouldberemovedbytheabovemand.C、AnysynonymexistingontheEMPtablewouldhavetobere-created.D、AnyindexcreatedontheMGRincolumnwouldcontinuetoexistuntiltheDROPUNUSEDCOLUMNSmandisexecuted.答案：B30.YouwanttowriteaquerythatpromptsfortwocolumnnamesandtheWHEREconditioneachtimeitisexecutedinasessionbutonlypromptsforthetablenamethefirsttimeitisexecuted.

Thevariablesusedinyourqueryareneverundefinedinyoursession.

Whichquerycanbeused?A、SELECT&&col1,&&col2FROM&tableWHERE&&condition=&&cond;B、SELECT&col1,&col2FROM&&tableWHERE&condition;C、SELECT&col1,&col2FROM“&table”WHERE&condition;D、SELECT‘&&col1’,‘&&col2’FROM&tableWHERE‘&&condition’=‘&cond’;E、SELECT&&col1,&&col2FROM&tableWHERE&&condition;答案：B31.YouwanttousetablepressionsuitableforOLTPthatwill:

1pressrowsforallDMLstatementsonthattable

2Minimizetheoverheadsassociatedwithpression

Whichpressionoptionisbestsuitedforthis?A、COLUMNSTOREPRESSFORQUERYLOWB、ROWSTOREPRESSBASICC、COLUMNSTOREPRESSFORARCHIVELOWD、COLUMNSTOREPRESSFORARCHIVEHIGHE、ROWSTOREPRESSADVANCED答案：E32.WhichisthedefaultcolumnorcolumnsforsortingoutputfrompoundqueriesusingSEToperatorssuchasINTERSECTinaSQLstatement?A、thefirstNUMBERorVARCHAR2columninthelastselectofthepoundqueryB、thefirstNUMBERcolumninthefirstselectofthepoundqueryC、thefirstvARCHAR2columninthefirstselectofthepoundqueryD、thefirstcolumninthefirstselectofthepoundquery答案：D33.TheCUSTOMERStablehasaCUST_LASTNAMEcolumnofdatatypeVARCHAR2ThetablehastworowswhoseCUST_LASTNAMEvaluesareAndersonandAusson

WhichqueryproducesoutputforCUST_LASTNAMEcontainingoderforthefirstrowandAusforthesecond?A、SELECTREPLACE(SUBSTR(cust_last_name,-3),'AN',"O')FROMcustomers;B、SELECTINITCAPREPLACE(TRIM('SONFROMcust_last_namE.,'AN,'O'))FROMcustomers;C、SELECTREPLACE(TRIM(TRAILING"SON'FROMcustlastnamE.,'AN,'O')FROMcustomersD、SELECTREPLACE(REPLACE(custlastname,'son','),'AN','O')FROMcustomers;答案：D34.Whichstatementistrueaboutdatabaselinks?A、Adatabaselinkcreatedinadatabaseallowsaconnectionfromthatdatabase'sinstancetothetargetdatabase'sinstance,butnotviceversaB、PrivatedatabaselinkcreationrequiresthesameusertoexistinboththelocalandtheremotedatabasesC、ApublicdatabaselinkcanbeusedbyauserconnectedtothelocaldatabaseinstancetoconnecttoanyschemaintheremotedatabaseinstanceD、ApublicdatabaselinkcanbecreatedonlybysysE、AdatabaselinkcanbecreatedonlybetweentwoOracledatabases答案：E35.Inthespfileofasingleinstancedatabase,LOCALLISTENERissettoLISTENER1.

TheTNSNAMESORAfileinSORACLEHOME/network/admininthedatabasehomecontains:

LISTENER1=(ADDRESS=

(PROTOCOL=TCP)

(HOST=host1abc.)(PORT=1521))

Whichstatementistrue?A、TherearetwolistenersnamedLISTENERandLISTENER1runningsimultaneouslyusingport1521onthesamehostasthedatabaseinstancesB、ThedefinitionforLISTENER1requiresaCONNECTDATAsectiontoenabledynamicserviceregistrationC、LISTENER1mustalsobedefinedintheLISTENER.ORAfiletoenabledynamicserviceregistrationD、TheLREGprocessregistersservicesdynamicallywiththeLISTENER_1listenerE、Dynamicserviceregistrationcannotbeusedforthisdatabaseinstance答案：D36.ExaminethedescriptionofthePRODUCT_INFORMATIONtables:

NameNull?Type

PROD_IDNOTNULLNUMBER(2)

PROD_NAMEVARCHAR2(10)

LIST_PRICENUMBER(6,2)

Whichqueryretrievesthenumberofprofuctswithanulllistprice?A、SELECTCOUNT(list_pricE.FROMproduct_informationWHERElist_price=NULL;B、SELECTCOUNT(list_pricE.FROMproduct_informationWHERElist_priceISNULL;C、SELECTCOUNT(NVL(list_price,0))FROMproduct_informationWHERElist_priceISNULL;D、SELECTCOUNT(DISTINCTlist_pricE.FROMproduct_informationWHERElist_priceISNULL;答案：C37.Youexecutethisquery:SELECTTO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE.,‘MON’),‘dd“Mondayfor”fmMonthrrrr’)Whatistheresult?A、ItexecutessuccessfullybutdoesnotreturnanyresultB、ItreturnsthedateforthefirstMondayofthenextmonthC、ItgeneratesanerrorD、ItreturnsthedateforthelastMondayofthecurrentmonth答案：B38.Examinethedetailsoftheunpressed,non-partitionedheaptableCITIES.

NameNull?Type

CITYIDNOTNULLNUMBER(4)

CITY_NAMEVARCHAR2(50)

Examinethemand:SQL>ALTERTABLEcitiesSHRINKSPACEPACT;

Whatmustyoudobeforeexecutingit?A、Ensuretherearenopendingtransactionsonthetable.B、Disableallindexesonthetable.C、Ensurefreespacethatisapproximatelyequaltothespaceusedbythetableshouldbeavailable.D、Enablerowmovementisenabled.答案：D39.ThestorestablehasacolumnSTART_DATEofdatatypeDATE,containingthedatetherowwasinserted.

YouonlywanttodisplaydetailsofrowswhereSTART_DATEiswithinthelast25months.

Whichwhereclausecanbeused?A、WHEREMONTHS_BETWEEN(SYSDATE,start_datE.<=25B、WHERETO_NUMBER(start_date-SYSDATE.<=25C、WHEREADD_MONTHS(start_date,25)<=SYSDATED、WHEREMONTHS_BETWEEN(start_date,SYSDATE.<=25答案：D多选题1.Examinethesemands

Whichtwostatementsaretrueaboutthesqlldrexecution?

A、ItoverwritesthedataforAlanandaddsdataforCurlandBobB、ItgeneratesasqlscriptthatitusestoloaddatafromEMP.DATtoEMPC、ItoverwritesalldatainEMPwithdatafromEMP.DAT.D、Itgeneratesalogthatcontainscontrolfileentries,whichcanbeusedwithnormalSQL*LoaderoperationsE、ItappendsdatafromEMP.DATtoEMP.答案：DE2.Whichthreestatementsaretrueabouttimezones,datedatatypes,andtimestampdatatypesinanOracledatabase?(Choosethree.)A、TheCURRENT_TIMESTAMPfunctionreturnsdatawithouttimezoneinformationB、ATIMESTAMPWITHLOCALTIMEZONEdatatypecolumnisstoredinthedatabaseusingthetimezoneofthesessionthatinsertedtherowC、ATIMESTAMPdatatypecolumncontainsinformationaboutyear,month,anddayD、TheDBTIMEZONEfunctioncanreturnanoffsetfromUniversalCoordinatedTime(UTC.E、TheSESSIONTIMEZONEfunctioncanreturnanoffsetfromUniversalCoordinatedTime(UTC.答案：BCE3.Whichtwostatementsaretrueaboutsinglerowfunctions?A、MOD:returnstheremainderofadivisionoperation.B、CONCAT:canbeusedtobineanynumberofvalues.C、TRUNC:canbeusedonlywithNUMBERdatatypes.D、FLOOR:returnsthesmallestintegergreaterthanorequaltoaspecifiednumber.E、CEIL:canbeusedforpositiveandnegativenumbers.答案：AE4.Inoneofyourdatabases,youcreateauser,HR,andthenexecutethismandGRANTCREATESESSIONTOhrWITHADMINOPTION:

WhichthreeactionscanHRperform?A、GranttheCREATESESSIONprivilegewithADMTNOPTIONtootherusersB、Logintothedatabaseinstance.C、RevoketheCREATEsessionprivilegefromotherusersD、ExecuteDDLstatementsintheHRschemaE、ExecuteDMLstatementsintheHRschemaF、RevoketheCREATESESSIONprivilegefromuserHR答案：ACF5.Whichthreeactivitiesarerecordedinthedatabasealertlog?A、blockcorruptionerrorsB、DataDefinitionLanguage(DDL)statementsC、Non-defaultdatabaseparametersD、deadlockerrorsE、sessionloginsandlogouts答案：ACD6.Whichthreestatementsaretrueaboutinnerandouterjoins?A、OuterjoinscanbeusedwhentherearemultiplejoinconditionsontwotablesB、OuterjoinscanonlybeusedbetweentwotablesperqueryC、AleftorrightouterjoinreturnsonlyunmatchedrowsD、AfullouterjoinreturnsmatchedandunmatchedrowsE、AninnerjoinreturnsmatchedrowsF、AfullouterjoinmustuseOraclesyntax答案：ADE7.WhichtwostatementsaretrueabouttheUNLIMITEDTABLESPACEsystemprivilegeandspacequotas?A、ItallowsaroletohaveunlimitedspaceinanytablespaceinthedatabaseB、ItisoverriddenbyaspacequotaspecifiedfortheuserC、Itallowsausertohaveunlimitedspaceonlyintheirdefaultpermanenttablespace.D、Bydefault,usershavenoquotaontheirdefaultpermanenttablespace.E、Itallowsausertohaveunlimitedspaceinanytablespaceinthedatabase答案：AE8.WhichtwostatementsaretrueaboutINTERVALdatatypes?A、INTERVALYEARTOMONTHcolumnssupportyearlyintervalsB、TheYEARfieldinanINTERVALYEARTOMONTHcolumnmustbeapositivevalueC、ThevalueinanINTERVALDAYTOSECONDcolumncanbecopiedintoanINTERVALYEARTOMONTHcolumnD、INTERVALYEARTOMONTHcolumnsonlysupportmonthlyintervalswithinasingleyearE、INTERVALDAYTOSECONDcolumnssupportfractionsofsecondsF、INTERVALYEARTOMONTHcolumnsonlysupportmonthlyintervalswithinarangeofyears答案：AE9.WhichthreestatementsaretrueaboutadvancedconnectionoptionssupportedbyOracleNetforconnectiontoOracleDatabaseinstances?(Choosethree.)A、ConnectTimeFailoverrequirestheuseofTransparentApplicationFailover(TAF.B、SourceRoutingrequirestheuseofanameserverC、SourceRoutingenablestheuseofConnectionManager(CMAN)whichenablesnetworktraffictoberoutedthroughafirewallD、LoadBalancingcanbalancethenumberofconnectionstodispatcherswhenusingaSharedServerconfigurationE、LoadBalancingrequirestheuseofanameserverF、ConnectTimeFailoverrequirestheconnectstringtohavetwoormorelisteneraddressesconfigured答案：CDF10.choosethreeWhichthreestatementsaretrueabouttimezones,datedatatypes,andtimestampdatatypesinanoracledatabase?A、TheDBTIMEZONEfunctioncanreturnanoffsetfromUniversalCoordinatedTime(UTC..B、ATIMESTAMPdatatypecolumncontainsinformationaboutyear,month,andday.C、ATIMESTAMPWITHLOCALTIMEZONEdatatypecolumnisstoredinthedatabaseusingthetimezoneofthesessionthatinsertedtherow.D、TheSESSIONTIMEZONEfunctioncanreturnanoffsetfromUniversalCoordinatedTime(UTC..E、TheCURRENT_TIMESTAMPfunctionreturnsdatawithouttimezoneinformation.答案：BCD11.choosethreewhichthreestatementsaretrueaboutGLOBALTEMPORARYTABLES?A、ADELETEandonGLOBALTEMPORARYTABLEcannotberolledbackB、GLOBALTEMPORARYTABLErowsinsertedbyasessionareavailabletoanyothersessionwhoseuserhasbeengrantedselectedonthetableC、AnyGLOBALTEMPORARYTABLErowsexstingatsessionterminationwillbedeletedD、AGLOBALTEMPORARYTABLE'sdefinitionisavailabletomultiplesessions;E、GLOBALTEMPORARYTABLEspaceallocationoccursatsessionstart.F、ATRUNCATEmandissuesinasessioncausesallrowsinaGLOBALTEMPORARYTABLEfortheissuingsessiontobedeleted.答案：CDF12.WhichthreestatementsaretrueabouttheOraclejoinandANSIjoinsyntax?(Choosethree.)A、TheOraclejoinsyntaxsupportscreationofaCartesianproductoftwotablesB、TheOraclejoinsyntaxperformsbetterthantheSQL:1999pliantANSIjoinsyntaxC、TheSQL:1999pliantANSIjoinsyntaxsupportsnaturaljoinsD、TheSQL:1999pliantANSIjoinsyntaxsupportscreationofaCartesianproductoftwotablesE、TheOraclejoinsyntaxonlysupportsrightouterjoinsF、TheOraclejoinsyntaxsupportsnaturaljoins

G)TheOraclejoinsyntaxperformslesswellthantheSQL:1999pliantANSIjoinsyntax答案：ABF13.TableEMPLOYEEScontainscolumnsincludingEMPLOYEE_ID,JOB_IDandSALARY.OnlytheEMPLOYEE_IDcolumnisindexed.Rowsexistforemployees100and200.Examinethisstatement:Whichtwostatementsaretrue?(Choosetwo.)A、Employee100willhaveSALARYsettothesamevalueastheSALARYofemployee200B、Employee200willhaveJOB_IDsettothesamevalueastheJOB_IDofemployee100C、Employee200willhaveSALARYsettothesamevalueastheSALARYofemployee100D、Employee100willhaveJOB_IDsettothesamevalueastheJOB_IDofemployee200E、Employees100and200willhavethesameJOB_IDasbeforetheupdatemandF、Employees100and200willhavethesameSALARYasbeforetheupdatemand答案：AD14.WhichthreearetypesofsegmentsinanOracleDatabase?(Choosethree.)A、undoB、indexC、storedproceduresD、sequencesE、tablesF、clusters答案：ABE15.TableORDERITEMScontainscolumnsORDERID,UNITPRICEandQUANTITY,ofdatatypeNUMBER.

ExaminetheseSQLstatements

Whichtwostatementsaretrue?

A、Statement1returnsonlyonerowofoutput.B、Statement2mayreturnmultiplerowsofoutput.C、Statement2returnsonlyonerowofoutput.D、Boththestatementsgivethesameoutput.E、BothstatementswillreturnNULLifeitherUNITPRICEorQUANTITYcontainsNULL答案：AB16.WhichthreestatementsaretrueabouttheAutomaticDiagnosticRepository(ADR)?A、Itisafile-basedrepositoryheldoutsideanydatabaseB、TheADRbaseisspecifiedintheDIAGNOSTICDESTdatabaseparameteC、ItisonlyusedforOracleDatabasediagnosticinformationD、ItisheldinsideanOracledatabaseschemaE、Itcanbeusedforproblemdiagnosisofadatabasewhenthatdatabase'sinstanceisdown答案：ABE17.TheSALEStablehascolumnsPROD_IDandQUANTITYSOLDofdatatypeNUMBER.Whichtwoqueriesexecutesuccessfully?A、SELECTprodidFROMsalesWHEREquantitysold>55000ANDCOUNT(*)>10GROUPBYprodidHAVINGCOUNT(*)>10:B、SELECTCOUNT(prodiD.FROMsalesGROUPBYprodidWHEREquantity_sold>55000C、SELECTprodidFROMsalesWHEREquantitysold>55000ANDCOUNT(*)>10GROUPBYCOUNT(*)>10:D、SELECTprodidFROMsalesWHEREquantitysold>55000GROUPBYprodidHAVINGCOUNT(*)>10;E、SELECTCOUNT(prodiD.FROMsalesWHEREquantity_sold>55000GROUPBYprodid;答案：DE18.Whichtwostatementsaretrueaboutdate/timefunctionsinasessionwhereNLS_DATE_FORMATissettoDD-MON-YYYYHH24:MI:SS?(Choosetwo.)A、CURRENT_TIMESTAMPreturnsthesamedateandtimeasSYSDATEwithadditionaldetailsoffractionalsecondsB、SYSDATEcanbequeriedonlyfromtheDUALtableC、CURRENT_DATEreturnsthecurrentdateandtimeasperthesessiontimezoneD、SYSDATEcanbeusedinexpressionsonlyifthedefaultdateformatisDD-MON-RRE、SYSDATEandCURRENT_DATEreturnthecurrentdateandtimesetfortheoperatingsystemofthedatabaseserverF、CURRENT_TIMESTAMPreturnsthesamedateasCURRENT_DATE答案：CE19.WhichtwostatementsaretrueabouttheSETVERIPYONmand?A、Itdisplaysvaluesforvariablesprefixedwith&&B、ItdisplaysvaluesforvariablescreatedbytheDEFINEmandC、ItcanbeusedinSQLDeveloperandSQL*PlusD、ItcanbeusedonlyinSQL*PlusE、ItdisplaysvaluesforvariablesusedonlyintheWHEREclauseofaquery答案：BC20.Examinethismand

Whichtwostatementsaretrue?

A、DML,maybeperformedontableswithoneormoreextentsinthisdatafileduringtheexecutionofthismandB、ItoverwritesanyexistingfilewiththenameSALES02.DBFin/u02bydefault.C、TableswithoneormoreextentsinthisdatafilemaybequeriedduringtheexecutionofthismandD、pressedobjectsinsales01.DBFwillbeunpressedinSALES02.DBFafterthemoveE、The"To"clausecontainingthenewfilenamemustbespecifiedevenifOracleManagedFiles(OMF.isused答案：AC21.Whileoneofyourdatabaseswasinmountstate,thedatafileswererenamedbecausetheyhadbeenmovedtoanewfilesystemThedatabasewasthenopenedWhichtwostatementsaretrue?A、DBADATAFILESdisplaysboththenewnameandtheoldnameforthedatafilesB、DBADATAFILESdisplaystheoriginalnameforthedatafilesC、V$DATAEILEdisplaysthenewnamesforthedatafilesD、DBADATAFILESmustberesynchronizedmanuallywiththecontrolfileinordertohaveitdisplaythenewfilenamesE、DBADATAFILESdisplaysthenewnameforthedatafiles答案：CE22.Inyourdatacenter,OracleManagedFiles(OMF.isusedforalldatabasesAlltablespacesaresmallfiletablespaces

SALE_Q1isapermanentuser-definedtablespaceinthesalesdatabase

ExaminethismandwhichisabouttobeissuedbyaDBAloggedintothesalesdatabaseALTERTABLESPACEsales_q1ADDDATAFILE;

Whicharetwoactions,eitheroneofwhichyoucouldtaketoensurethatthemandexecutessuccessfully?A、EnsurethatDB_RECOVERY_FILE_DESTandDBCREATE_FILE_DESTeachspecifylocationswithatleast50MbofavailablespaceB、AddtheAUROEXRENDowclausewithNEXTsetto100M.C、SpecifyapathintheDAMAPILEclauseofthemandspecifyingalocationwithatleast100MofavailablespaceD、EnsurethatDB_RECOVERY_FILE_DESTspecifiesalocationwithatleast100MbofavailablespaceE、EnsurethatDB_RECOVERY_FILE_DESTandDB_CREATE_FILE_DESTeachspecifylocationswithatleast50Mbofavailablespace答案：BD23.Whichthreefunctionsareperformedbydispatchersinasharedserverconfiguration?(Choosethree.)A、writinginboundrequesttothemonrequestqueuefromallsharedserverconnectionsB、checkingforoutboundsharedserverresponsesonthemonoutboundresponsequeueC、receivinginboundrequestsfromprocessesusingsharedserverconnectionsD、sendingeachconnectioninputrequesttotheappropriatesharedserverinputqueueE、broadcastingsharedserversessionresponsesbacktorequestersonallconnectionsF、sendingsharedserversessionresponsesbacktorequestersontheappropriateconnection答案：ADF24.ExaminethedescriptionoftheBOOKStable:Thetablehas100rows.Examinethissequenceofstatementsissuedinanewsession:

INSERTINTObooksVALUES(‘ADV112’,‘AdventuresofTomSawyer’,NULL,NULL);

SAVEPOINTa;

DELETEFROMbooks;

ROLLBACKTOS