nerdexam
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

1Z0-074 question #79 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)
  • A
    75% (27)
  • B
    3% (1)
  • C
    14% (5)
  • D
    8% (3)

Explanation

Explanation/Reference:

Topics

#SQL plan management#SPM baselines#capture filter#SQL workload

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice