单项选择题

FromtheV$SESSION_LONGOPSview，youfindthatsomeofthedatabaseusershavelong-runningqueriesthatconsumealotofCPUtime.Thiscausesperformanceproblemsforotherusersinthedatabase，whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime，butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis？（）
A.settheCPUtimepercallintheusersprofile
B.settheCPUtimepersessionintheusersprofiles
C.settheCPUlevelsfortheusers’groupusingResourceManager
D.settheTIMED_STATISTICSparametertoTRUEintheparameterfile

A.Thiscausesperformanceproblemsforotherusersinthedatabase，whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime，butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis？（）
A.settheCPUtimepercallintheusersprofile
B.settheCPUtimepersessionintheusersprofiles
C.settheCPUlevelsfortheusers’groupusingResourceManager
D.settheTIMED_STATISTICSparametertoTRUEintheparameterfile
<上一题 目录 下一题>
热门 试题

未分类题
构建“三全”服务体系整体要求是什么?
未分类题
以下描述属于云计算的特任的是()
单项选择题
The（）writestheFlashbackDatabaselogsintheflashrecoveryarea.
A.FLSH
B.FLDB
C.RVWR
D.RVRW
E.FBDA
未分类题
疑难投诉处理闭环三确认是什么()
未分类题
营业厅炒害营销推荐包括()步?
单项选择题
WhichpseudocolumncouldyouusetoidentifyauniquerowinaFlashbackVersionsQuery？（）
A.XID
B.VERSIONS_PK
C.VERSIONS_XID
D.VERSIONS_UNIQUE
未分类题
按照渠道转型发展要求，全渠道角达体系包括哪些内涵?
未分类题
大数据有哪些待点?
单项选择题
Attherequestofauser，youissuethefollowingcommandtorestoreadroppedtable：flashbacktable BIN$F2JFfMq8Q5unbC0ceE9eJg==$0 tobeforedrop；Later，theusernotifiesyouthatthedatainthetableseemstobeveryoldandoutofdate.Whatmightbetheproblem？（）A.BecauseaproperrangeofSCNswasnotspecified，thewrongdatawasrestored.B.Aproperrangeoftimestampswasnotspecified，sothewrongdatawasrestored.C.ApreviousFlashbackDropoperationhadbeenperformed，resultinginmultipleversionsofthetablebeingstoredintheRecycleBin.D.EitheroptionAorBcouldbecorrect.Notenoughinformationwasprovidedtodeterminewhich.E.Noneoftheabove.
A.Whatmightbetheproblem？（）
A.BecauseaproperrangeofSCNswasnotspecified，thewrongdatawasrestored.
B.Aproperrangeoftimestampswasnotspecified，sothewrongdatawasrestored.
C.ApreviousFlashbackDropoperationhadbeenperformed，resultinginmultipleversionsofthetablebeingstoredintheRecycleBin.
D.EitheroptionAorBcouldbecorrect.Notenoughinformationwasprovidedtodeterminewhich.
E.Noneoftheabove.
单项选择题
Yourdatabaseisstartedbyusingtheserverparameterfile（SPFILE）.YouissuedthiscommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=24MSCOPE=BOTHWhatwouldbetheoutcomeofthiscommand？（）A.ThecommandwouldreturnanerrorbecauseLOG_BUFFERisastaticparameter.B.Theparametervaluewouldbechangedanditwouldcomeintoeffectimmediately.C.Youneedtorestartthedatabasesothatparameterchangescancomeintoeffect.D.ThecommandwouldsucceedonlyifinitializationparameterLOG_ARCHIVE_MAX_PROCESSissettovalue2.
A.YouissuedthiscommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=24MSCOPE=BOTHWhatwouldbetheoutcomeofthiscommand？（）
A.ThecommandwouldreturnanerrorbecauseLOG_BUFFERisastaticparameter.
B.Theparametervaluewouldbechangedanditwouldcomeintoeffectimmediately.
C.Youneedtorestartthedatabasesothatparameterchangescancomeintoeffect.
D.ThecommandwouldsucceedonlyifinitializationparameterLOG_ARCHIVE_MAX_PROCESSissettovalue2.
相关试题