oracle dba 资料(oca.ocp.1Z0-042_168.pdf)

1.Whichthreepiecesofinformationareconsideredwhiledecidingthesizeoftheundotablespaceinyourdatabase?(Choosethree.)A)thesizeofanundoblockB)thesizeoftheredologfilesC)undoblocksgeneratedpersecondD)thesizeofthedatabasebuffercacheE)thevalueoftheUNDO_RETENTIONparameter2.YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate?A)renamingthecontrolfilesB)droppingauserinyourdatabaseC)enablingordisablingredologarchivingD)droppingatablespaceinyourdatabaseE)re-creatingthecontrolfiles,afteryoulostallthecontrolfilesinyourdatabase3.Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase,youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective?A)UsetheCREATEDATABASE..commandtocreatethedatabasewithOracle-managedfiles.B)UsetheDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithOracle-managedfiles.C)UseEnterpriseManagertocreateanewdatabasewiththeOnlineTransactionProcessing(OLTP)option.D)UseDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithTransactionProcessingtemplate.E)UsetheCREATEDATABASE..commandtocreatethedatabasewithAutomaticStorageManagement(ASM)filesystem.4.Whichthreestatementsaretrueaboutthestagesofdatabasestartup?(Choosethree.)A)DatafilesandredologfilescanberenamedattheMOUNTstage.B)ControlfilesarereadattheOPENstageforthelocationofdatafiles.C)ControlfilesarerequiredtobringthedatabasetotheNOMOUNTstage.D)DatafilesandredologfilesaremadeavailabletousersattheOPENstage.E)Datafilesandonlineredologfilesarecheckedforconsistencywhileopeningthedatabase.5.AconstraintinatableisdefinedwiththeINITIALLYIMMEDIATEclause.YouexecutedtheALTERTABLEcommandwiththeENABLEVALIDATEoptiontoenabletheconstraintthatwasdisabled.Whatarethetwoeffectsofthiscommand?(Choosetwo.)A)Itfailsifanyexistingrowviolatestheconstraint.B)Itdoesnotvalidatetheexistingdatainthetable.C)Itenablestheconstrainttobeenforcedattheendofeachtransaction.D)Itpreventsinsert,update,anddeleteoperationsonthetablewhiletheconstraintisintheprocessofbeingenabled.6.YoureceivedcomplaintsaboutthedegradationofSQLqueryperformance.YouidentifiedtopSQLqueriesthatconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance?A)runSegmentAdvisorB)runSQLTuningAdvisorontopSQLstatementsC)runtheAutomaticWorkloadRepository(AWR)reportD)runtheAutomaticDatabaseDiagnosticMonitor(ADDM)ontopSQLstatements7.TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andundoretentionisnotguaranteed.Whichstatementregardingretentionofundodataiscorrect?A)Undodatabecomesobsoleteafter1,000seconds.B)Undodatagetsrefreshedafterevery1,000seconds.C)Undodatawillbestoredpermanentlyafter1,000seconds.D)Committedundodatawouldberetainedfor1,000secondsiffreeundospaceisavailable.E)UndodatawillberetainedintheUNDOtablespacefor1,000seconds,thenitgetsmovedtotheTEMPORARYtablespacetoprovidereadconsistency.8.ViewtheExhibit.Whichstatementregardingthedeptandemptablesistrue?A)Whenyoudeletearowfromtheemptable,youwouldreceiveaconstraintviolationerror.B)Whenyoudeletearowfromthedepttable,youwouldreceiveaconstraintviolationerror.C)Whenyoudeletearowfromtheemptable,automaticallythecorrespondingrowsaredeletedfromthedepttable.D)Whenyoudeletearowfromthedepttable,automaticallythecorrespondingrowsaredeletedfromtheemptable.E)Whenyoudeletearowfromthedepttable,automaticallythecorrespondingrowsareupdatedwithnullvaluesintheemptable.F)Whenyoudeletearowfromtheemptable,automaticallythecorrespondingrowsareupdatedwithnullvaluesinthedepttable.9.Whichthreestatementsarecorrectabouttemporarytables?(Choosethree.)A)Indexesandviewscanbecreatedontemporarytables.B)Boththedataandthestructureoftemporarytablescanbeexported.C)Temporarytablesarealwayscreatedinauser'stemporarytablespace.D)Thedatainsertedintoatemporarytableinasessionisavailabletoothersessions.E)Datamanipulationlanguage(DML)locksareneveracquiredonthedataoftemporarytables.10.WhichstatementregardingthecontentsoftheV$PARAMETERviewistrue?A)displaysonlythelistofdefaultvaluesB)displaysonlythelistofallbasicparametersC)displaysthecurrentlyineffectparametervaluesD)displaysonlythelistofalladvancedparametersE)displaysthelistofalltheparameterfilesofadatabaseF)displaysthecurrentcontentsoftheserverparameterfile11.Accordingtoyourbackupstrategy,youperformedanincrementallevel0backupofyourdatabase.Whichstatementregardingthisbackupistrue?A)Thebackupissimilartoimagecopy.B)Thebackupcontainsalluseddatablocks.C)Thebackupcontainsonlyunuseddatablocks.D)Thebackupcontainsalldatablockschangedsincethelastincrementallevel1backup.12.WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAiniSQL*Plus?A)Theusermustbegrantedthedatabaseadministrator(DBA)privilege.B)Theusermustbelistedinthepasswordfilefortheauthentication.C)NospecialsetupisneededfortheusertoconnectasSYSDBAiniSQL*Plus.D)SetupauserintheOracleApplicationServerContaine