Why would you use the FALSE value for the CASCADE parameter while dropping the baseline?

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?

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?

A.
because it does not remove snapshots associated with the baseline

B.
because it does not drop the template that is used to create the baseline

C.
because it does not remove the baseline from the performance page if it appears there

D.
because it does not remove the Automatic Database Diagnostic Management (ADDM) results from the Automatic Workload Repository (AWR) that were generated using the baseline



Leave a Reply 0

Your email address will not be published. Required fields are marked *