Which two statements are true regarding the SQL Repair Advisor?()A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL state

题目
Which two statements are true regarding the SQL Repair Advisor?()

A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.


相似考题
更多“Which two statements are true regarding the SQL Repair Advisor?() ”相关问题
  • 第1题:

    This bike needs () (repair).


    参考答案:repairing

  • 第2题:

    下列复选框构造方法,错误的是 ( )

    A.setLayout(new GridLayout(3,1));

    B.add(new Checkbox("one",null,true));

    C.add(new Checkbox("two"));

    D.add(new Checkbox("one",true));


    正确答案:D
    解析:该题考查复选框的构造方法。构造方法的一般格式为:public Checkbox (String label,CheckboxGrou Pgroup,boolean state)。选项A、B、C都是正确的,而选项D是错误的,它的第二个参数应该是CheckboxGrou Pgroup,所以选项D是错误的。

  • 第3题:

    WhichcomponentoftheOraclenetworkingarchitectureprovidescharactersetanddatatypeconversionbetweendifferentcharactersetsontheclientandserver?()

    A.SQL*Plus

    B.OracleNet

    C.Two-TaskCommon(TTC)

    D.OracleProtocolSupport(OPS)


    参考答案:C

  • 第4题:

    Evaluatethefollowingcode:SQL>VARIABLEtask_nameVARCHAR2(255);SQL>VARIABLEsql_stmtVARCHAR2(4000);SQL>BEGIN:sql_stmt:=’SELECTCOUNT(*)FROMcustomersWHEREcust_state_province=’’CA’’’;:task_name:=’MY_QUICKTUNE_TASK’;DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,:task_name,:sql_stmt);END;Whatistheoutcomeofthisblockofcode?()

    A.Itcreatesataskandworkload,andexecutesthetask.

    B.Itcreatesataskandworkloadbutdoesnotexecutethetask.

    C.Itproducesanerrorbecauseatemplatehasnotbeencreated.

    D.ItproducesanerrorbecausetheSQLTuningSethasnotbeencreated.


    参考答案:A

  • 第5题:

    下列复选框构造方法,错误的是()。

    A.setLayout(newGridLayout(3,1));

    B.add(newCheckbox("one",null,true));

    C.add(newCheckbox("tWO");

    D.add(newCheckbox("one",true);


    正确答案:D

  • 第6题:

    Import for the first three months this year is larger than that for the__________period last year.


    A.relating

    B.concerning

    C.corresponding

    D.regarding

    答案:C
    解析:
    考查词义辨析。句意为“今年前三个月的进口量比上一年同期多”。relating to“相关的”,concerning“关于”,corresponding“相当的,对应的”,regarding“关于;就……而论”。根据句意可知是今年前三个月和去年相对应的前三个月做对比.故选C。