Thefollowingcommandisexecutedtocreatethebaselinetemplate:SQL>EXECUTEDBMS_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)

题目

Thefollowingcommandisexecutedtocreatethebaselinetemplate:SQL>EXECUTEDBMS_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);Whichstatementistrueabouttheeffectoftheabovecommand?()

A.Itcreatesabaselinetemplatethatneverexpires.

B.Itproducesanerrorbecausenosnapshotinformationisprovidedtocreatethebaseline.

C.ItcreatesabaselinetemplatethatexpiresaftertheAutomaticWorkloadRepository(AWR)retentionperiod.

D.ItcreatesarepeatingbaselinetemplatethatrepeatsaftertheAutomaticWorkloadRepository (AWR)retentionperiod.


相似考题