1Z0042WORD标红版.docx

1Z0042WORD标红版.docx

《1Z0042WORD标红版.docx》由会员分享，可在线阅读，更多相关《1Z0042WORD标红版.docx（63页珍藏版）》请在冰豆网上搜索。

1Z0042WORD标红版

1.Whichthreepiecesofinformationareconsideredwhiledecidingthesizeoftheundotablespaceinyourdatabase?

（Choosethree.）

A）thesizeofanundoblock

B）thesizeoftheredologfiles

C）undoblocksgeneratedpersecond

D）thesizeofthedatabasebuffercache

E）thevalueoftheUNDO_RETENTIONparameter

2.YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate?

A）renamingthecontrolfiles

B）droppingauserinyourdatabase

C）enablingordisablingredologarchiving

D）droppingatablespaceinyourdatabase

E）re-creatingthecontrolfiles,afteryoulostallthecontrolfilesinyourdatabase

3.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）runSegmentAdvisor

B）runSQLTuningAdvisorontopSQLstatements

C）runtheAutomaticWorkloadRepository（AWR）report

D）runtheAutomaticDatabaseDiagnosticMonitor（ADDM）ontopSQLstatements

7.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.Whichstatementregardingthe