网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Inyourtestdatabase，youfindthatauser’ssessionisexecutingalotofSQLstatements，resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason，youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace，remotely，onlyforthatusersessiontoreducethevolumeoftracedatabeinggenerated.Howdoyouachievethisobjective？（）
A.bysettingtheSQL_TRACEparametertoFALSEintheparameterfile
B.byusingDBMS_MONITOR.SESSION_TRACE_DISABLEtodisablethetracingfortheusersession
C.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSYSTEMcommandintheusersession
D.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSESSIONcommandintheusersession
参考答案
更多 “ Inyourtestdatabase，youfindthatauser’ssessionisexecutingalotofSQLstatements，resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason，youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace，remotely，onlyforthatusersessiontoreducethevolumeoftracedatabeinggenerated.Howdoyouachievethisobjective？（）A.bysettingtheSQL_TRACEparametertoFALSEintheparameterfileB.byusingDBMS_MONITOR.SESSION_TRACE_DISABLEtodisablethetracingfortheusersessionC.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSYSTEMcommandintheusersessionD.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSESSIONcommandintheusersession ” 相关考题
考题
Inyourtestdatabase，youhavecreatedtheORDERStableasanindexorganizedtable（IOT）.To facilitatefasterquerying，youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegradeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason，youfindthatthemappingtablesegmentisfragmented，leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata？（）A.exportandimportthemappingtableB.dropandrecreatethemappingtableC.truncatethemappingtableandreinsertthevaluesD.usetheALTERTABLE..REBUILDcommandtodefragmentthemappingtable
考题
Inyourtestdatabase，youhavecreatedtheORDERStableasanindex-organizedtable（IOT）.Tofacilitatefasterquerying，youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegradeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason，youfindthatthemappingtablesegmentisfragmented，leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata？（）A.exportandimportthemappingtableB.dropandre-createthemappingtableC.truncatethemappingtableandreinsertthevaluesD.usetheALTERTABLE···REBUILDcommandtodefragmentthemappingtable
热门标签
最新试卷