You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease

题目
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()

A. Compute the baseline statistics.

B. Take an immediate AWR snapshot.

C. Decrease the window size for the baseline.

D. Decrease the expiration time for the baseline.

相似考题

1.”You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would

2.If you don’t like to swim, you _____as well stay at home.A)should B)may C)can D)would

3."You _________ finish your homework before the dinner." said mother.A.shouldB.have toC.mustD.would

4.7． If I _______ you，l_______ take an umbrella with me．A． was ; shouldB． was ; wouldC． were ; willD． were ; would

更多“You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?() ”相关问题

  • 第1题：

    企业信息安全策略必须通过循环的修正才能进一步完善，这个循环是：()

    A、Plan->Do->Action->Check

    B、Do->Plan->Action->Check

    C、Plan->Do->Check->Action

    D、Do->Action->Check->Plan


    参考答案：C

  • 第2题：

    inyourdatabaseinstance,theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting()

    A.Optimizerstatisticsarecollectedautomatically.

    B.Onlytimedoperatingsystem（OS）statisticsandplanexecutionstatisticsarecollected.

    C.ThesnapshotsfortheAutomaticWorkloadRepository（AWR）arenotgeneratedautomatically.

    D.SnapshotscannotbecollectedmanuallybyusingtheDBMS_WORKLOAD_REPOSITORYpackage.

    E.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.


    参考答案：C

  • 第3题：

    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.


    参考答案：A

  • 第4题：

    Inyourdatabase,theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting?()

    A.Theoptimizerstatisticsarecollectedautomatically.

    B.Onlythetimedoperatingsystem（OS）statisticsandplanexecutionstatisticsarecollected.

    C.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.

    D.ThesnapshotsfortheAutomaticWorkloadRepository（AWR）arenotgeneratedautomatically.

    E.SnapshotscannotbecollectedmanuallybyusingDBMS_WORKLOAD_REPOSITORYPACKAGE.


    参考答案：D

  • 第5题：

    YouworkasadatabaseadministratorforSupportcenter.cn.YouhavesettheretentionperiodforAutomaticRepository（AWR）statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics？（）

    A.useenterprisemanager

    B.useDBMS_SQLpackage

    C.useDBMS_AWRpackage

    D.usePRVT_WORKLOADpackage

    E.querytheAWRsnapshotrepositoryobjects

    F.useDBMS_WORKLOAD_REPOSITORYpackage


    参考答案：A, F

  • 第6题：

    “You ____ have a wrong number,” she said. “There’s no one of that name here.”

    A. need

    B. can

    C. must

    D. would


    正确答案：C
    解析：must have意思是肯定有什么，依题意可得，答案是C。

相关内容