多项选择题
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?()