1Z0042WORD标红版Word格式.docx
- 文档编号:15827923
- 上传时间:2022-11-16
- 格式:DOCX
- 页数:63
- 大小:1,004.14KB
1Z0042WORD标红版Word格式.docx
《1Z0042WORD标红版Word格式.docx》由会员分享,可在线阅读,更多相关《1Z0042WORD标红版Word格式.docx(63页珍藏版)》请在冰豆网上搜索。
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?
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?
A)Indexesandviewscanbecreatedontemporarytables.
B)Boththedataandthestructureoftemporarytablescanbeexported.
C)Temporarytablesarealwayscreatedinauser'
stemporarytablespace.
D)Thedatainsertedintoatemporarytableinasessionisavailabletoothersessions.
E)Datamanipulationlanguage(DML)locksareneveracquiredonthedataoftemporarytables.
10.Whichstatementregardingthe
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Z0042WORD 标红版
![提示](https://static.bdocx.com/images/bang_tan.gif)