Which statement is true about the effect of the above command?

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=>’Mytemp4l,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?

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=>’Mytemp4l,
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 *