black

1z0-043

登录

多项选择题

You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze?()

A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized view logs

相关考题

单项选择题 YouaremanaginganOracleDatabase10gdatabasethatusesOracleManagedFiles(OMF).Youenabledtheblockchangetrackingfeatureforthedatabase.Whichstatementregardingthechangetrackingfileistrue?()

单项选择题 You execute the following command to enable a session in resumable mode:  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;  What is the impact of a timeout on the statements being suspended?()

单项选择题 Inyourtestdatabase,youfindthatauser’ssessionisexecutingalotofSQLstatements,resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason,youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace,remotely,onlyforthatusersessiontoreducethevolumeoftracedatabeinggenerated.Howdoyouachievethisobjective?()

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号:湘ICP备14005140号-5

经营许可证号:湘B2-20140064