nerdexam
Oracle

1Z0-054 · Question #164

Examine the following block: BEGIN DBMS_WORKLOAD_REPOSITORY. DROP_BASELINE (baseline_name => 'peak baseline', cascade => FALSE, dbid => 3310949047); END; Why would you use the FALSE value for the…

The correct answer is A. because it does not remove snapshots associated with the baseline. See the full explanation below for the reasoning.

Question

Examine the following block:

BEGIN DBMS_WORKLOAD_REPOSITORY. DROP_BASELINE (baseline_name => 'peak baseline', cascade => FALSE, dbid => 3310949047); END; Why would you use the FALSE value for the CASCADE parameter while dropping the baseline?

Options

  • Abecause it does not remove snapshots associated with the baseline
  • Bbecause it does not drop the template that is used to create the baseline
  • Cbecause it does not remove the baseline from the performance page if it appears there
  • Dbecause it does not remove the Automatic Database Diagnostic Management (ADDM) results

How the community answered

(44 responses)
  • A
    77% (34)
  • B
    5% (2)
  • C
    7% (3)
  • D
    11% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice