WhichofthefollowingarenotfundamentaltasksoftheSupportWorkbench?()
A.Viewlong-runningSQLworkloads
B.Viewproblemdetails
C.Gatheradditionaldiagnosticinformation
D.CreateaServiceRequest
E.CleanupincidentdataafteruploadtoOracleSupport
A.Viewlong-runningSQLworkloads
B.Viewproblemdetails
C.Gatheradditionaldiagnosticinformation
D.CreateaServiceRequest
E.CleanupincidentdataafteruploadtoOracleSupport
第1题
raftertheINSERTstatementisissuedandfewrowsareinserted:INSERTINTOEMP_DEP(emp_id,name,salary,dep_name,mgr_id)*ERRORatline1:ORA-01653:unabletoextendtableSCOTT.EMP_DEPby128intablespaceUSERSIdentifytwoactionseitherofwhichwillhelpyouresolvethisproblem.()
A.GranttheRESOURCEroletoSCOTT.
B.AdddatafilestotheUSERStablespace.
C.GranttheCREATEANYTABLEprivilegetoSCOTT.
D.IncreasethespaceforSCOTTontheUSERStablespace.
E.IncreasethesizeofthedatafileassociatedwiththeUSERStablespace
第2题
separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC?()
A. A base catalog exists
B. The recovery catalog is empty
C. The base recovery catalog must be dropped
D. A target database is registered in the recovery catalog
第3题
A.CleansuptheADRbydeletingfilesnotassociatedwithanincidentuploadedtoOracleSupport.
B.IdentifiesallfilesassociatedwithacriticalerrorandaddsthemtoazipfiletobesenttoOracleSupport.
C.AutomaticallyopensaServiceRequestwithOracleSupportforeachcriticalerrorandsendsallrelevantfiles.
D.Displaysahigh-levelviewofcriticalerrorsonthedatabasehomepage.
第4题
finsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto,inordertofindinformationabouttablefragmentation?()
A.MemoryAdvisor
B.SegmentAdvisor
C.SQLTuningAdvisor
D.SQLAccessAdvisor
E.AutomaticDatabaseDiagnosticMonitor(ADDM)
第5题
A.Schedule,createnewpackage,viewmanifest,viewcontents
B.Createnewpackage,viewmanifest,viewcontents,schedule
C.Schedule,createnewpackage,viewcontents,viewmanifest
D.Createnewpackage,viewcontents,viewmanifest,schedule
E.Noneoftheabove.
第6题
A. failures because a data file is renamed by error
B. failures when no standby database is configured
C. failures that require no archive logs to be applied for recovery
D. failures due to loss of connectivity-for example, an unplugged disk cable
第7题
suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()
A.MemoryAdvisor
B.SegmentAdvisor
C.SQLAccessAdvisor
D.AutomaticWorkloadRepository(AWR)
E.AutomaticDatabaseDiagnosticMonitor(ADDM)
第8题
A.ReducedMTTR.
B.Datafilesremainofflinewhilecorruptblocksarerepaired.
C.Datafilesremainonlinewhilecorruptblocksarerepaired.
D.AandC
第9题
A.increasethesizeofredologfiles
B.increasethesizeoftheundotablespace
C.increasethesizeoftheDatabaseBufferCache
D.increasethesizeofthedefaulttemporarytablespace
E.enabletheretentionguaranteefortheundotablespace
第10题
A.ANALYZEoperations
B.dbv
C.SQLqueriesthataccessthepotentiallycorruptblock
D.RMAN
E.Alloftheabove
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!