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_TIMESTAMP(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_TIMESTAMP(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 *