Oracle
1Z0-074 · Question #79
Examine this parameter: Examine these commands: Which three are true after executing these commands? (Choose three.)
The correct answer is A. All statements executed by SH are captured and included in a baseline. E. Statements executed by any user containing the "TEST_ONLY" string are excluded from capture. F. Only repeatable statements executed by SYS and SH are considered for baselines. Explanation/Reference:
New Features for Performance
Question
Examine this parameter:
Examine these commands:
Which three are true after executing these commands? (Choose three.)
Exhibit
Options
- AAll statements executed by SH are captured and included in a baseline.
- BStatements executed by both SH and SYS may be captured and included in a baseline.
- COnly statements executed by SYS are captured and included in a baseline.
- DOnly statements executed by SH containing the "TEST_ONLY" string are excluded from capture.
- EStatements executed by any user containing the "TEST_ONLY" string are excluded from capture.
- FOnly repeatable statements executed by SYS and SH are considered for baselines.
How the community answered
(36 responses)- A75% (27)
- B3% (1)
- C14% (5)
- D8% (3)
Explanation
Explanation/Reference:
Topics
#SQL plan management#SPM baselines#capture filter#SQL workload
Community Discussion
No community discussion yet for this question.
