The DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE procedure is used to create a

repeating baseline template in the Automatic Workload Repository (AWR). This template will

generate baselines for a specified duration of time on a repeating schedule. The parameters of the

CREATE_BASELINE_TEMPLATE procedure include the start and end times, as well as the day of the

week and hour in the day when the baseline should be captured.

Given that the command specifies a repeating baseline every Monday at 5 PM with a duration of 3

hours and it expires after 30 days, the number of baselines generated by this command that you can

have at any given time depends on how many Mondays fall within the most recent 30-day period.

Since the maximum number of Mondays that can occur within any 30-day period is 5 (four to five

weeks), but considering the baseline has a duration of 3 hours and starts every Monday at 5 PM, only

one baseline for each Monday can exist at a time. However, since baselines are preserved for 30

days, you could have multiple instances of Monday baselines preserved at a time.

A (Incorrect): There can be more than one baseline at a time because the template will generate a

baseline for every Monday during the 30-day expiration period.

B (Incorrect): There will be more than three baselines because the template creates a baseline for

every Monday within the 30-day expiration period.

C (Correct): Over a 30-day period, considering the duration of the baselines and their frequency, you

could have up to a maximum of 52 baselines if you consider the entire year.

D (Incorrect): There is no option that restricts the number of baselines to 5 specifically, the answer

relies on the calculation of how many baselines can exist over a period of time considering their

expiration.

Reference:

Oracle Database PL/SQL Packages and Types Reference: DBMS_WORKLOAD_REPOSITORY