（新）OCP认证082考试题库及答案

PAGEPAGE63（新）OCP认证082考试题库及答案一、单选题1.ViewtheExhibitsandexaminethestructureofthecostsandPROMOTIONStables

YouwanttodisplayPRODIDSwhosepromotioncostislessthanthehighestcostPRODIDinapromotiontimeinterval

ExaminethisSQLstatement

Whatwillbetheresult?A、Itexecutessuccessfullyandgivestherequiredresult.B、ItgivesanerrorbecausetheGROUPBYclauseisnotvalidC、ItexecutessuccessfullybutdoesnotgivetherequiredresultD、ItgivesanerrorbecausetheALLkeywordisnotvalid答案：C2.ExaminethedescriptionoftheSATES1table

SALES2isatablewiththesamedescriptionassAleS1Somesalesdataiscontainederroneouslyinbothtables

YoumustdisplayrowsfromsAlEs1andSALESandwishtoseetheduplicatestooWhichsetoperatorgeneratestherequiredoutput?

A、MINUSB、UNIONALLC、SUBTRACTD、UNIONE、INTERSECT答案：B3.YourdatabaseinstanceisstartedwithaPFILE.

Examinetheseparameters:

Youwanttoincreasethesizeofthebuffercache.Freememoryisavailabletoincreasethesizeofthebuffercache.Youexecutethemand:SQL>ALTERSYSTEMSETDB_CACHE_SIZE=1024M;

Whatistheoute?A、ThevalueischangedonlyinthePFILEandtakeseffectatthenextinstancestartupB、ThevalueischangedforthecurrentinstanceandinthePFILEC、ItfailsbecausetheSCOPEclauseismissingD、Changeisappliedtothecurrentinstance,butdoesnotpersistafterinstancerestart答案：D4.Whichstatementistrueaboutdatabaselinks?A、Adatabaselinkcreatedinadatabaseallowsaconnectionfromthatdatabase'sinstancetothe

Targetdatabase'sinstance,butnotviceversaB、PrivatedatabaselinkcreationrequiresthesameusertoexistinboththelocalandtheremotedatabasesC、ApublicdatabaselinkcanbeusedbyauserconnectedtothelocaldatabaseinstancetoconnecttoanyschemaintheremotedatabaseinstanceD、ApublicdatabaselinkcanbecreatedonlybysysE、AdatabaselinkcanbecreatedonlybetweentwoOracledatabases答案：C5.WhichstatementistrueabouttheINTERSECToperatorusedinpoundqueries?A、MultipleINTERSECToperatorsarenotpossibleinthesameSQLstatementB、ItprocessesNULLSintheselectedcolumnsC、INTERSECTisoflowerprecedencethanUNIONorUNIONALLD、ItignoresNULLS答案：B6.YourdatabaseinstanceisstartedwithanSPFILEAPFILEisalsoavailable

Youexecutethismand

ALTERSYSTEMSETDBCACHESIZE=100K

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

Whichqueryretrievesthenumberofproductswithanulllistprice?A、SELECTCOUNT(listprice)FROMproductinformationWHERElistpriceNULLB、SELECTCOUNT(listprice)FROMproductinformationWHERElistpriceIsNULL,C、SELECTCOUNT(DISTINCTlistprice)PROMproductinformationWHERElistpriceIsNULL:D、SELECTCOUNT(NVL(listprice,0))FROMproductinformationWHERElistpriceIsNULL答案：D8.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、Thejoinsyntaxusedmakesnodifferencetoperformance.B、TheBETWEENconditionusedwithannon-equijoinsometimesperformsbetterthanusingthe>=and<=conditionsC、TheBETWEENconditionusedwithannon-equijoinalwaysperformsbetterthanwhenusingthe>=and<=conditionsD、TheOraclejoinsyntaxperformsbetterthanthesol:1999pliantANSIjoinsyntaxE、TheOraclejoinsyntaxperformslesswellthanthesol:1999pliantANSIjoinsyntax答案：A10.AdatabaseisconfiguredtouseautomaticundomanagementwithtemporaryundoenabledAnUPDATEisexecutedonatemporarytable

WhereistheUNDOstored?A、intheundotablespaceB、intheSYSAUXtablespaceC、intheSGAD、inthePGAE、inthetemporarytablespace答案：E11.ExaminethedescriptionoftheCUSTOMERStable:

Forcustomerswhoseinelevelhasavalue,youwanttodisplaythefirstnameanddueamountas5%

Oftheircreditlimit.Customerswhosedueamountisnullshouldnotbedisplayed.Whichqueryshouldbeused?A、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AMOUNT

FROMcustomersWHEREcust_ins_levelISNOTNULLANDdue_amountISNOTNULL;B、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AMOUNT

FROMcustomersWHEREcust_ine_level!=NULLANDcust_credit_level!=NULL;C、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AMOUNT

FROMcustomersWHEREcust_ine_level<>NULLANDdue_amount<>NULL;D、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AMOUNT

FROMcustomersWHEREcust_ine_level!=NULLANDdue_amount!=NULL;E、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AMOUNTFROMcustomersWHEREcust_ine_levelISNOTNULLANDcust_credit_limitISNOTNULL;答案：E12.YouwanttowriteaquerythatpromptsfortwocolumnnamesandtheWHEREconditioneachtimeitIs

ExecutedinasessionbutonlypromptsforthetablenamethefirsttimeitisexecutedThevariablesusedinyourqueryareneverundefinedinyoursession

Whichquerycanbeused?A、SELECT&&col1&&co2FROM&tableWHERE&&condition=&&condB、SELECT&col1&COI2FROM&&tableWHERE&conditionC、SELECT&col1&CO12FROM&tableWHERE&conditionD、ELECT&&col1&&coFROM&tableWHERE&&condition=&condE、SELECT&&col1&&COL2FROM&tableWHERE&&condition答案：B13.WhichpressionmethodisremendedforDirect-PathInsertoperations?A、COLUMNSTOREPRESSADVANCEDB、ROWSTOREPRESSADVANCEDC、COLUMNSTOREPRESSBASICD、ROWSTOREPRESSBASIC答案：D14.YouwanttousetablepressionsuitableforOLTPthatwill:1-pressrowsforallDMLstatementsonthattable

2-MinimizetheoverheadsassociatedwithpressionWhichpressionoptionisbestsuitedforthis?A、COLUMNSTOREPRESSFORQUERYLOWB、ROWSTOREPRESSBASICC、COLUMNSTOREPRESSFORARCHIVELOWD、COLUMNSTOREPRESSFORARCHIVEHIGHE、ROWSTOREPRESSADVANCED答案：E15.ExaminethedescriptionoftheCUSTOMERStable

YouwanttodisplaydetailsofallcustomerswhoresideincitiesstartingwiththeletterDfollowedbyat

LeasttwocharactersWhichquerycanbeused?A、SELECT"FROMcustomersWHEREcityLIKEDB、SELECT*FROMcustomersWHEREC、SELECT"FROMcustomersWHEREcityLIKEDD、SELECT"FROMcustomersWHEREcity=D答案：A16.WhichisthedefaultcolumnorcolumnsforsortingoutputfrompoundqueriesusingSEToperatorssuchasINTERSECTinaSQLstatement?A、thefirstNUMBERorVARCHAR2columninthelastselectofthepoundqueryB、thefirstNUMBERcolumninthefirstselectofthepoundqueryC、thefirstvARCHAR2columninthefirstselectofthepoundqueryD、thefirstcolumninthefirstselectofthepoundqueryE、thefirstcolumninthelastselectsofthepoundquery答案：D17.YouhavebeentaskedtocreateatableforabankingapplicationOneofthecolumnsmustmeetthreerequirements:

BestoredinaformatsupportingdatearithmeticwithoutusingconversionfunctionsStorealoanperiodofupto10years

BeusedforcalculatinginterestforthenumberofdaystheloanremainsunpaidWhichdatatypeshouldyouuse?A、INTERVALYEARTOMONTHB、INTERVALDAYTOSECONDC、TIMESTAMPWITHLOCALTIMEZONED、TIMESTAMPE、TIMESTAMPWITHTIMEZONE答案：B18.Inthespfileofasingleinstancedatabase,LOCALLISTENERissettoLISTENER1.

TheTNSNAMESORAfileinSORACLEHOME/network/admininthedatabasehomecontains:LISTENER1=

(ADDRESS=(PROTOCOL=TCP)

(HOST=host1abc.)(PORT=1521)

)

Whichstatementistrue?A、TherearetwolistenersnamedLISTENERandLISTENER1runningsimultaneouslyusingport1521onthesamehostasthedatabaseinstancesB、ThedefinitionforLISTENER1requiresaCONNECTDATAsectiontoenabledynamicserviceregistrationC、LISTENER1mustalsobedefinedintheLISTENER.ORAfiletoenabledynamicserviceregistrationD、TheLREGprocessregistersservicesdynamicallywiththeLISTENER_1listenerE、Dynamicserviceregistrationcannotbeusedforthisdatabaseinstance答案：A19.Inthespfileofasingleinstancedatabase,LOCALLISTENERissettoLISTENER.1

TheTNSNAMES.ORAfileinSORACLEHOME/network/admininthedatabasehomecontains

Whichstatementistrue?A、DynamicserviceregistrationcannotbeusedforthisdatabaseinstanceB、TheLREGprocessregistersservicesdynamicallywiththeLISTENER1listenerC、LISTENER_1mustalsobedefinedintheLISTENER.ORAfiletoenabledynamicserviceregistrationD、TherearetwolistenersnamedLISTENERandLISTENER1runningsimultaneouslyusingport1521onthesamehostasthedatabaseinstances

ThedefinitionforLISTENER1requiresaCONNECTDATAsectiontoenabledynamicservice答案：D20.TheCUSTOMERStablehasaCUST_LASTNAMEcolumnofdatatypeVARCHAR2ThetablehastworowswhoseCUST_LASTNAMEvaluesareAndersonandAusson

WhichqueryproducesoutputforCUST_LASTNAMEcontainingoderforthefirstrowandAusforthe

Second?A、SELECTREPLACE(SUBSTR(cust_last_name,-3),'AN',"O')FROMcustomers;B、SELECTINITCAPREPLACE(TRIM('SONFROMcust_last_namE.,'AN,'O'))FROM

Customers;C、SELECTREPLACE(TRIM(TRAILING"SON'FROMcustlastnamE.,'AN,'O')FROM

CustomersD、SELECTREPLACE(REPLACE(custlastname,'son','),'AN','O')FROMcustomers;答案：D21.Examinethedescriptionoftheproductstable

A、SELECTprodid,AVG(MAX(cost))FROMproductsGROUPBYprod.B、SELECTprodid,MAX(AVG(cost))FROMproductsGROUPBYprodid:C、Selectprodid,releasedate,SUM(cost)FROMproductsGROUPBYprodidD、SELECTprodid,releasedate,SUM(cost)FROMproductsGROUPBYprodid,releasedate答案：D多选题1.WhichthreestatementsaretrueaboutsequencesinasingleinstanceOracledatabase?A、AsequencenumberthatwasallocatedcanberolledbackifatransactionfailsB、AsequencecanonlybedroppedbyaDBAC、SequencescanalwayshavegapsD、Asequencecanissueduplicatevalues.E、Asequence'sunallocatedcachedvaluesarelostiftheinstanceshutsdownF、Twoormoretablescannothavekeysgeneratedfromthesamesequence答案：CDE2.WhichthreestatementsaretrueaboutusingSQL*Plus?A、Itcanrunscriptspassedtoitbyashellscript.B、ItcanrunscriptsenteredattheSQLpromptC、Ithasbothmand-lineandgraphicaluserinterfaces(Gun)D、IthasitsownmandsthatareseparatefromanySQLstatementsE、ItcanrunRecoveryManager(RMAN)mandsF、ItmustbedownloadedfromtheOracleTechnologyNetwork(OTN)答案：BCD3.Examinethesemands

Whichtwostatementsaretrueaboutthesqlldrexecution?A、ItoverwritesthedataforAlanandaddsdataforCurlandBobB、ItgeneratesasqlscriptthatitusestoloaddatafromEMP.DATtoEMPC、ItoverwritesalldatainEMPwithdatafromEMP.DAT.D、Itgeneratesalogthatcontainscontrolfileentries,whichcanbeusedwithnormalSQL*LoaderoperationsE、ItappendsdatafromEMP.DATtoEMP.答案：DE4.WhichtwostatementsaretrueaboutundosegmentsandtheuseofundobytransactionsinanOracle

DatabaseinstanceA、Asingletransactionmayusemultipleundosegmentssimultaneously.B、UndosegmentscanbestoredintheSYSAUXtablespaceC、UndosegmentscanextendwhenatransactionfillsthelastextentoftheundosegmentD、UndosegmentscanwraparoundtothefirstextentwhenatransactionfillsthelastextendoftheundosegmentE、UndosegmentscanbestoredintheSYSTEMtablespace答案：DE5.Whichtwostatementsaretrueaboutsubstitutionvariables?A、Asubstitutionvariableusedtopromptforacolumnnamemustbeenclosedindoublequotationmarks.B、AsubstitutionvariableprefixedwithsalwayspromptsonlyonceforavalueinasessionC、AsubstitutionvariableusedtopromptforacolumnnamemustbeenclosedinsinglequotationmarksD、Asubstitutionvariableprefixedwith&&promptsonlyonceforavalueinasessionunlessitissettoundefinedinthesessionE、AsubstitutionvariablecanbeusedonlyinaSELECRstatementF、Asubstitutionvariablecanbeusedwithanyclauseinaselectstatement答案：DF6.TheORDERStablehasacolumnORDERDATEofdatatypeDATE.ThedefaultdisplayformatforadateisDD-MON-RR

WhichtwoWHEREconditionsdemonstratethecorrectusageofconversionfunctions?A、WHEREorderdateTODATE(ADDMONTHS(SYSDATE,6),'MONDDYYYY')B、WHERETOCHAR(orderdate,'MONDDYYYY')='JAN202019'C、WHEREorderdate>TODATE(JUL102018','NONDDYYYY')D、WHEREorderdateTOCHAR(ADDMONTHS(SYSDATE,6),'MONDDYYYY)E、WHEREorderdateIN(ToDATE('oct212018','monDDYYYY'),roCHAR('Nov212018','MonDDYYYY'))答案：BC7.Inoneofyourdatabases,youcreateauser,HR,andthenexecutethismandGRANTCREATESESSIONTOhrWITHADMINOPTION:

WhichthreeactionscanHRperform?A、GranttheCREATESESSIONprivilegewithADMTNOPTIONtootherusersB、Logintothedatabaseinstance.C、RevoketheCREATEsessionprivilegefromotherusersD、ExecuteDDLstatementsintheHRschemaE、ExecuteDMLstatementsintheHRschemaF、RevoketheCREATESESSIONprivilegefromuserHR答案：ACF8.Whichthreestatementsaretrueaboutsingle-rowfunctions?(Choosethree.)A、TheycanbeusedonlyintheWHEREclauseofaSELECTstatementB、Theargumentcanbeacolumnname,variable,literaloranexpressionC、ThedatatypereturnedcanbedifferentfromthedatatypeoftheargumentD、TheycanbenestedtoanylevelE、Theycanacceptonlyoneargument

Theyreturnasingleresultrowpertable答案：BCD9.WhichthreestatementsaretrueabouttheAutomaticDiagnosticRepository(ADR)?A、Itisafile-basedrepositoryheldoutsideanydatabaseB、TheADRbaseisspecifiedintheDIAGNOSTICDESTdatabaseparameteC、ItisonlyusedforOracleDatabasediagnosticinformationD、ItisheldinsideanOracledatabaseschemaE、Itcanbeusedforproblemdiagnosisofadatabasewhenthatdatabase'sinstanceisdow答案：ABE10.Whichthreestatementsaretrueaboutaselfjoin?A、ItcanbeanouterjoinB、TheONclausecanbeusedC、ThequerymustusetwodifferentaliasesforthetableD、ItmustbeanequijoinE、ItmustbeaninnerjoinF、TheONclausemustbeused答案：ABC11.InthePROMOTIONstable,thePROMOBEGINDATEcolumnisofdatatypeDATEandthedefaultdateformatisDD-MON-RR

WhichtwostatementsaretrueaboutexpressionsusingPROMOBEGINDATEcontainedinaquery?A、PROMOBEGINDATE-SYSDATEwillreturnanumberB、TODATE(PROMOBEGINDATE*5)willreturnadateC、TONUMBER(PROMOBEGINDATE.-5willreturnanumberD、PROMOBEGINDATE-SYSDATEwillreturnanerrorE、PROMOBEGINDATE-5willreturnadate答案：AE12.WhichthreestatementsaretrueaboutGLOBALTEMPORARYTABLES?A、AGLOBALTEMPORARYTABLEcanhaveonlyoneindexB、AtriggercanbecreatedonaGLOBALTEMPORRYTABLEC、DataManipulationLanguage(DML)onGLOBALTEMPORARYTABLESgeneratesnoREDOD、AGLOBALTEMPORARYTABLEcannothaveaPUBLICSYNONYME、AGLOBALTEMPORARYTABLEcanbereferencedinthedefiningqueryofaview.F、AGLOBALTEMPORARYTABLEcanhavemultipleindexes.答案：BEF13.Youmustcreateatablespaceofnon-standardblocksizeinanewfilesystemandplantousethismand

Thestandardblocksizeis8kbutothernon-standardblocksizeswillalsobeusedWhichtwoarerequirementsforthismandtosucceed?A、DB32KCACHESIZEmustbesettoavaluethatcanbeacmodatedintheSGAB、DB32KCACHESIZEshouldbesettoavaluegreaterthanDBCACHESIZEC、DB32KCACHESIZEmustbelessthanDBCACHESIZED、Theoperatingsystemmustusea32kblocksizeE、DBCACHESIZEmustbesettoasizethatissmallerthanDB32KCACHESIZEF、The/uo2filesystemmusthaveatleast100gspaceforthedatafile答案：AF14.Whichtwoarebenefitsofexternaltables?A、TheysupportUPDATESwhichtransparentlyupdatesrecordsinthefilesystemasiftheyweretableB、TheycanbequeriedwhilethedatabaseisintheMOUNTstatelikedynamicperformanceviewsC、TheysupportDELETEswhichtransparentlydeletesrecordsinthefilesystemasiftheyweretablerowsD、TheresultsofaplexjoinoraggregatingfunctionorbothcanbeunloadedtoafilefortransportationtoanotherdatabaseE、Theycanbequeried,transformed,andjoinedwithothertableswithouthavingtoloadthedatafirst答案：DE15.Whichtwostatementsaretrueconcerninglogicalandphysicaldatabasestructures?A、Asegment'sblockscanbeofdifferentsizes.B、AsegmentmighthaveonlyoneextentC、AlltablespacesmayhaveoneormoredatafilesD、SegmentscanspanmultipletablespacesE、Asegmentcanspanmultipledatafilesinsometablespaces答案：BE16.Whichthreestatementsaretrueregardingsinglerowsubqueries?A、TheymustbeplacedontheleftsideoftheparisonoperatororconditionB、TheymustreturnarowtopreventerrorsintheSQLstatementC、TheycanbeusedintheHAVINGclause.D、ASQLstatementmayhavemultiplesinglerowsubqueryblocksE、TheycanbeusedintheWHEREclauseF、Theymustbeplacedontherightsideoftheparisonoperatororcondition答案：CDE17.YoucurrentlyhaveanactivetransactioninyoursessionandhavebeengrantedselectaccesstoVSTRANSACTION

Inwhichthreesituationswillre-executingthisquerystillreturnarowbutwithadifferentXIDindicatinganewtransactionhasstarted?

A、aftersuccessfullyexecutingaTRUNCATEstatementfollowedbyaDMLstatementB、aftersuccessfullyexecutingaCREATETABLEASSelectstatementfollowedbyaSELECTFORUPDATEstatementC、aftersuccessfullyexecutingaCREATETABLEstatementfollowedbyaCREATEINDEXstatementD、aftersuccessfullyexecutingamitorROLLBACKfollowedbyaDMLstatementE、aftersuccessfullyexecutingaDMLstatementfollowingafailedDMLstatementF、aftersuccessfullyexecutingamitorROLLBACKfollowedbyaSelectstatement答案：ABD18.orcl.dmpcontainsafullexportoftheORCIdatabase

ThismandIsexecutedtoloaddatafromorcl.dmpintotheRESRDBdatabase

Whichtwostatementsaretrue?A、ItskipsonlytablesthatexistInbothORCL:SHandTESTDB:HRB、Itdropsandre-createstablesthatexistinbothORCL:SHandTESTDB:HR.C、ItskipsallindexesofORCL:SHandORCI:OED、Itdropsandre-createsindexesthatexistInbothORCI:SHandTESTDB:HRE、ItskipsonlyindexesthatexistinbothORCL:SHandTESTDB:HR答案：BC19.ExaminetheseSOLstatementswhichexecutesuccessfully

Whichtwostatementsaretrueafterexecution?A、TheprimarykeyconstraintwillbeenabledandIMMEDIATEB、TheforeignkeyconstraintwillbeenabledandDEFERREDC、TheforeignkeyconstraintwillbedisabledD、TheforeignkeyconstraintwillbeenabledandIMMEDIATEE、TheprimarykeyconstraintwillbeenabledandDEFERRED答案：AC20.WhichthreestatementsaretrueaboutDeferredSegmentCreationinOracledatabases?A、Itisthedefaultbehaviorfortablesandindexes.B、Itissupportedforsys-ownedtablescontainedinlocallymanagedtablespacesC、SessionsmaydynamicallyswitchbackandforthfromDEFERREDtoIMMEDIATEsegmentcreation.D、IndexesinherittheDEFERREDorIMMEDIATEsegmentcreationattributefromtheirparenttableE、ItissupportedforIndexOrganizedTables(IOTs)containedinlocallymanagedtablespaces.答案：ACD21.Whichtwostatementsaretrueaboutviews?A、Aviewmustonlyrefertotablesinitsdefiningquery.B、TheWITHCHECKclausepreventscertainrowsfrombeingdisplayedwhenqueryingtheviewC、Viewscanbeupdatedwithouttheneedtore-grantprivilegesontheviewD、TheWITHCHECKclausepreventscertainrowsfrombeingupdatedorinsertedintheunderlying

Tablethroughtheview.E、Viewscanbeindexed答案：CD22.Whichthreeactivitiesarerecordedinthedatabasealertlog?A、blockcorruptionerrorsB、DataDefinitionLanguage(DDL)statementsC、Non-defaultdatabaseparametersD、deadlockerrorsE、sessionloginsandlogouts答案：ACD23.WhichtwoaretrueaboutaSQLstatementusingSEToperatorssuchasUNION?A、ThedatatypeofeachcolumnreturnedbythesecondquerymustexactlymatchthedatatypeofthecorrespondingcolumnreturnedbythefirstqueryB、Thenumber,butnotnames,ofcolumnsmustbeidenticalforallSELECTstatementsinthequeryC、ThenamesandnumberofcolumnsmustbeidenticalforallSELECTstatementsinthequeryD、ThedatatypeofeachcolumnreturnedbythesecondqueryisautomaticallyconvertedtothedatatypeofthecorrespondingcolumnreturnedbythefirstqueryE、Thedatatypegroupofeachcolumnreturnedbythesecondquerymustmatchthedatatypegroupofthecorrespondingcolumnreturnedbythefirstquery答案：BE24.WhichtwostatementsaretrueregardingaSAVEPOINT?(Choosetwo.A、RollingbacktoaSAVEPOINTcanundoaCREATEINDEXstatementB、RollingbacktoaSAVEPOINTcanundoaTRUNCATEstatementC、OnlyoneSAVEPOINTmaybeissuedinatransactionD、ASAVEPOINTdoesnotissueaMITE、RollingbacktoaSAVEPOINTcanundoaDELETEstatement答案：DE25.hichthreefunctionsareperformedbydispatchersinasharedserverconfiguration?(ChoosethreeA、writinginboundrequesttothemonrequestqueuefromallsharedserverconnectionsB、checkingforoutboundsharedserverresponsesonthemonoutboundresponsequeueC、receivinginboundrequestsfromprocessesusingsharedserverconnectionsD、sendingeachconnectioninputrequesttotheappropriatesharedserverinputqueueE、broadcastingsharedserversessionresponsesbacktorequestersonallconnectionsF、sendingsharedserversessionresponsesbacktorequestersontheappropriateconnection答案：ACF26.ExaminethedescriptionoftheBOORSTRANSACTIONStable:

WhichtwoWHEREconditionsgivethesameresult?

A、WHEREborroweddate=SYSDATEAND(transaction_type='RM'AND(member_id'A101'ORmemberid='A102'))B、WHEREborroweddate=SYSDATEAND(transactiontype='RM'ORmemberidIN('A101','A102'))C、WHEREborroweddate=SYSDATEAND(transactiontype='RM'ANDmember_id'A101'ORmemberid='A102')D、WHEREborroweddate=SYSDATEANDtransactiontype='RM'ORmemberidIN('A101','A102')E、WHERE(borroweddate=SYSDATEANDtransactiontype='RM')ORmemberidINA101','A1021)答案：DE27.WhichthreetasksareperformedbybackgroundprocessesinanOracledatabaseinstance?A、registeringserviceswithOracleNetlistenersB、writingdirtydatabaseblockimagesfromthebuffercacheC、writingredotologfilesD、readingdatabaseblocksintothebuffercacheE、creatingdedicatedserverconnections答案：ABC28.Whichfourstatementsaretrueregardingprimaryandforeignkeyconstraintsandtheeffecttheycanhaveontabledata?A、ItispossibleforchildrowsthathaveaforeignkeytoremaininthechildtableatthetimetheparentrowisdeletedB、PrimarykeyandforeignkeyconstraintscanbedefinedatboththecolumnandtablelevelC、Atablecanhaveonlyoneprimarykeyandoneforeignkey.D、AtablecanhaveonlyoneprimarykeybutmultipleforeignkeysE、OnlytheprimarykeycanbedefinedatthecolumnandtablelevelF、Theforeignkeycolumnsandparenttableprimarykeycolumnsmusthavethesamenames.G、Itispossibleforchildrowsthathaveaforeignkeytobedeletedautomaticallyfromthechildtableatthetimetheparentrowisdeleted答案：ABDG29.WhichtwostatementsaretrueabouttheOraclejoinandANSIjoinsyntax?A、TheOraclejoinsyntaxperformsbetterthantheSQL:1999pliantANSIjoinsyntax.B、TheOraclejoinsyntaxlackstheabilitytodoouterjoinsC、TheSQL:1999pliantANSIjoinsyntaxsupportscreationofaCartesianproductoftwotablesD、TheOraclejoinsyntaxsupportscreationofaCartesianproductoftwotablesE、TheOraclejoinsyntaxperformslesswellthantheSQL:1999pliantANSIjoinsyntax答案：CD30.Youexecutethismand

Sufficientstorageisavailableinfilesystem/uo1

WhichtwostatementsaretrueabouttheBIGTbstablespace?(ChoosetwoA、AUTOEXTENDispossibleforthedatafileB、ItmustbebiggerthanthelargestSMALLFILEtablespaceC、AdditionaldatafilesmaynotbeaddedD、Itwillbeadictionary-managedtablespacebydefault

Itwillalwayshavea32Kblocksize答案：AC31.WhichtwostatementsaretrueaboutUNDOandUNDOtablespaces?A、AnUNDOtablespacemaybeownedbyonlyoneinstanceB、UNDOsegmentsareownedbySYSBACKUPC、UNDOsegmentsareownedbySYSTEM.D、TherecanbeonlyoneUNDOtablespacecreatedinadatabaseE、Aninstancewillcrashiftheactiveundotablespaceislost.答案：AD32.Whichthreestatementsaretrueaboutinnerandouterjoins?A、OuterjoinscanbeusedwhentherearemultiplejoinconditionsontwotablesB、OuterjoinscanonlybeusedbetweentwotablesperqueryC、AleftorrightouterjoinreturnsonlyunmatchedrowsD、AfullouterjoinreturnsmatchedandunmatchedrowsE、AninnerjoinreturnsmatchedrowsF、AfullouterjoinmustuseOraclesyntax答案：ADE33.WhichthreestatementsaretrueregardingtheUNIONandUNIONALLoperators?A、ThenumberofcolumnsselectedbythefirstSELECTstatementcanbegreaterthanthenumberselectedinsubsequentSELECTstatementsB、DuplicatesareeliminatedautomaticallybytheUNIONALLoperatorC、ThenumberofcolumnsselectedineachSELECTstatementmustbeidenticalD、NULISarenotignoredduringduplicatecheckingE、ThenamesofcolumnsselectedineachSELECTstatementmustbeidenticalF、ThenamesofcolumnsselectedineachSELECTstatementcanbeidenticalG、DuplicatescanoptionallybeeliminatedbytheUNIONoperator答案：CDF34.Whichtwostatementsaretrueabouttimezones,datedatatypes,andtimestampdatatypesinanOracledatabase?A、TheDBTIMEZONEfunctioncanreturnanoffsetfromUniversalCoordinatedTime(UTC.B、ATIMESTAMPWITHLOCALTIMEZONEdatatypecolumnisstoredinthedatabaseusingthetimezoneofthesessionthatinsertedtherowC、TheCURRENTTIMESTAMPfunctionreturnsdatawithouttimezoneinformationD、TheSESSIONTIMEZONEfunctioncanreturnanoffsetfromUniversalCoordinatedTime(UTC.E、TheDATEdatatypereturnsdatawithtimezoneinformation答案：BD35.Whichtwostatementsaretrueaboutsinglerowfunctions?A、FLOOR:retumsthesmallestintegergreaterthanorequaltoaspecifiednumberB、CEIL:canbeusedforpositiveandnegativenumbersC、CONCAT:canbeusedtobineanynumberofvaluesD、TRUNC:canbeusedonlywithNUMBERdatatypesE、MOD:returnstheremainderofadivisionoperation答案：BE36.Whileoneofyourdatabaseswasinmountstate,thedatafileswererenamedbecausetheyhadbeenmovedtoanewfilesystem

ThedatabasewasthenopenedWhichtwostatementsaretrue?A、DBADATAFILESdisplaysboththenewnameandtheoldnameforthedatafilesB、DBADATAFILESdisplaystheoriginalnameforthedatafilesC、V$DATAEILEdisplaysthenewnamesforthedatafilesD、DBADATAFILESmustberesynchronizedmanuallywiththecontrolfileinordertohaveitdisplaythenewfilenamesE、DBADATAFILESdisplaysthenewnameforthedatafiles答案：CE37.WhichthreestatementsaretrueaboutthePESCRIBEmand?A、ItcanbeusedfromSQLDeveloper.B、ItdisplaysallconstraintsthataredefinedforeachcolumnC、ItcanbeusedonlyfromSQL*PlusD、ItdisplaysthePRIMARYKEYconstraintforanycolumnorcolumnsthathavethatconstraint.E、ItdisplaystheNOTNULLconstraintforanycolumnsthathavethatconstraint.F、Itcanbeusedtodisplaythestructureofanexistingview答案：AEF38.WhichtwostatementsaretrueaboutUNDOandREDO?A、ThegenerationofUNDOgeneratesREDO.B、DML,modifiesOracledatabaseobjectsandgeneratesUNDOandREDOC、DMLmodifiesOracledatabaseobjectsandonlygeneratesUNDO.D、ThegenerationofREDOgeneratesUNDO.E、DMLmodifiesOracledatabaseobjectsandonlygeneratesREDO答案：AB39.WhichthreestatementsaretrueabouttheDESCRIBEmand?(Choosethree.)A、ItdisplaysthePRIMARYKEYconstraintforanycolumnorcolumnsthathavethatconstraintB、ItcanbeusedfromSQLDeveloperC、ItdisplaystheNOTNULLconstraintforanycolumnsthathavethatconstraintD、ItcanbeusedtodisplaythestructureofanexistingviewE、Itdisplaysallconstraintsthataredefinedforeachcolumn

ItcanbeusedonlyfromSQL*Plus答案：BCD40.Examinethismand

SQL>ALTERTABLEORDERSSHRINKSPACEPACT

Whichtwostatementsaretrue?A、QueriesandDMLstatementsareallowedonORDERswhiletheSHRINKisexecutingB、DependentindexesbeeUNUSABLEC、TheSHRINKoperationcausesrowstobemovedtoemptyspacestartingtowardtheendoftheORDERssegmentD、TheSHRINKoperationcausesrowstobemovedtoemptyspacestartingfromthebeginningoftheORDERssegment.E、OnlyqueriesareallowedonORDERswhiletheSHRINKisexecutingF、Thehigh-watermark(HWM)ofORDERsisadjusted答案：AD41.WhichtwostatementsaretrueaboutsegmenttypesinanOracleDatabase?A、Tablesegmentsalwayshavetwoormoreextents.B、IndexsegmentsalwayshavetwoormoreextentsC、Clustersegmentsmaycontaindatafrommultipletables.D、TemporarysegmentsareonlystoredinatemporarytablespaceE、Undosegmentsareonlystoredinanundotablespace答案：CD42.WhichthreearetypesofsegmentsinanOracleDatabase?A、clustersB、sequencesC、storedproceduresD、viewsE、undoF、tables答案：AEF43.WhichtwostatementsaretrueabouttheresultsofusingtheINRERSECRoperatorinpoundqueries?A、ReversingtheorderoftheintersectedtablescansometimesaffecttheoutputB、INTERSECTreturnsrowsmontobothsidesofthepoundqueryC、ColumnnamesineachSELECTinthepoundquerycanbedifferent.D、ThenumberofcolumnsineachSELECTinthepoundquerycanbedifferentE、INTERSECTignoresNULIS答案：BC44.WhichtwostatementsaretrueabouttheSETVERIPYONmand?A、Itdisplaysvaluesforvariablesprefixedwith&&B、ItdisplaysvaluesforvariablescreatedbytheDEFINEmandC、ItcanbeusedinSQLDeveloperandSQL*PlusD、ItcanbeusedonlyinSQL*PlusE、ItdisplaysvaluesforvariablesusedonlyintheWHEREclauseofaquery答案：BC45.WhichtwostatementsaretrueabouttheWHEREandHAVINGclausesinaSELECTstatement?

(Choosetwo.)A、AggregatingfunctionsandcolumnsusedinHAVINGclausesmustbespecifiedintheSELECTlistofa

QueryB、WHEREandHAVINGclausescanbeusedinthesamestatementonlyifappliedtodifferenttable

ColumnsC、TheHAVINGclausecanbeusedwithaggregatingfunctionsinsubqueriesD、TheWHEREclausecanbeusedtoexcluderowsbeforedividingthemintogroupsE、TheWHEREclausecanbeusedtoexcluderowsafterdividingthemintogroups答案：CD46.DATADIR1andDATADTR2aredatabasedirectoryobjectsExaminethismand

Whichtwostatementsaretrueabouttheexpdpoperation?A、Itcreatesdumpfillesfortheentiredatabase.B、Itfailsifthetotalsizeofthedumpfileismorethan2GB.C、ItcreatesdumpfilesonlyforobjectsintheSYSTEMschemaD、Itstartsonlywhenfourworkerprocessesareavailable.E、Itcreatesamastertabletostoredetailsoftheexportoperation答案：AE47.WhichtwostatementsaretrueaboutthePMONbackgroundprocess?A、ItrollsbacktransactionswhenaprocessfailsB、ItregistersdatabaseserviceswithalllocalandremotelistenersknowntothedatabaseinstanceC、ItfreesunusedtemporarysegmentsD、ItfreesresourcesheldbyabnormallyterminatedprocessesE、Itrecordscheckpointinformationinthecontrolfile答案：AD48.WhichtwostatementsaretrueabouttheconfigurationanduseofUNDORETENTIONwithnoGUARANTEED

RETENTION?A、UnexpiredUNDOisalwaysretainedB、UNDORETENTIONspecifiesforhowlongOracleattemptstokeepunexpiredUNDOC、UNDO_RETENTIONspecifiesforhowlongOracleattemptstokeepexpiredandunexpiredUNDO.D、UNDORETENTIONspecifieshowlongalltypesofUNDOareretainedE、ActiveUNDOisalways