The following command is executed to create the baseline template:
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(
START_TIME=> TO_TIESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>’Mybase4′,
TEMPLATE_NAME=>’Mytemp4′,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?
A.
It creates a baseline template that never expires.
B.
It produces an error because no snapshot information is provided to create the baseline.
C.
It creates a baseline template that expires after the Automatic Workload Repository
(AWR) retention period.
D.
It creates a repeating baseline template that repeats after the Automatic Workload
Repository (AWR) retention period.
CREATE_BASELINE_TEMPLATE Procedure Parameters
Parameter>>>Description
start_time>>>Start Time for the baseline to be created’
end_time>>>End Time for the baseline to be created
baseline_name>>>Name of baseline to be created
template_name>>>Name for the template
expiration>>>Expiration in number of days for the baseline. If NULL, then expiration is infinite, meaning do not drop baseline ever. Defaults to NULL
dbid>>>Database Identifier for baseline. If NULL, this takes the database identifier for the local database. Defaults toNULL.
day_of_week>>>Day of week that the baseline should repeat on. Specify one of the following values: SUNDAY, MONDAY, TUESDAY,WEDNESDAY, THURSDAY, FRIDAY, SATURDAY.
hour_in_day>>>Value of 0-23 to specify the Hour in the Day the baseline should start
duration>>>Duration (in number of hours) after hour in the day that the baseline should last
baseline_name_prefix>>>Name for baseline prefix. When creating the baseline, the name of the baseline will be the prefix appended with the date information.