Which statement is true about the effect of the above c…

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?

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.



Leave a Reply 0

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