Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()A. A list of SQL statements and recommendations for tuningB. A list of SQL statements that have been tuned by the Advisor, with before and after metricsC. Graphs show

题目
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()

A. A list of SQL statements and recommendations for tuning

B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics

C. Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes

D. All of the above

相似考题

1.［A］ turning ［B］ tuning ［C］ tucking ［D］ tugging

2.Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@prod as sysdbaSQL > VAR eid NUMBERSQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);Which two statements are true?（）A. Database operations will be monitored only when they consume a significant amount of resource.B. Database operations for all sessions will be monitored.C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.D. Only DML and DDL statements will be monitored for the session.E. All subsequent statements in the session will be treated as one database operation and will be monitored.

3.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.

4.YouacceptedtherecommendedSQLProfilebyexecutingthefollowingcode：DECLAREsqlprofile_namevarchar2（30）；BEGINsqlprofile_name：=DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（task_name=>’my_task’，profile_name=>’my_profile’）；END；Whichadvisorwillanalyzethisprofile？（）A.SQLAccessAdvisorB.UndoAdvisorC.SegmentAdvisorD.SQLTuningAdvisor

参考答案和解析
参考答案：A
更多“Which of these appropriately describes the results of a manual SQL Tuning Advisor task?() ”相关问题

  • 第1题：

    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）

    A. Execute the query and view Active Session History (ASH) for information about the query.

    B. Enable SQL trace for the query.

    C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


    参考答案：C

  • 第2题：

    当你输入95时，下列程序运行的结果是 results = int（input（'成绩为：')) if 100＞=results＞=90: print（'A') elif 90＞results＞=75: print（'B') elif 0＜=results＜75: print（'C') else: print（'输入错误！')

    A．A

    B．B

    C．C

    D．输入错误！


    B

  • 第3题：

    5、当你输入95时，下列程序运行的结果是 results = int（input（'成绩为：')) if 100＞=results＞=90: print（'A') elif 90＞results＞=75: print（'B') elif 0＜=results＜75: print（'C') else: print（'输入错误！')

    A．A

    B．B

    C．C

    D．输入错误！


    A

  • 第4题：

    No single individual can____handle this kind of responsibilities alone.

    A.efficiently
    B.adequately
    C.necessarily
    D.appropriately

    答案：B
    解析：
    本题考查词语辨析。题目意为：“没有哪一个人足以独自承担这样的责任。” A项efficiently“有效地，高效地”。B项 adequately“充分地，足够地，适当地”。C项necessarily “必要地，必定地”。D项appropriately“适当地，合适地”。
    　　

  • 第5题：

    STAR原则是指提问关于行为事件的问题时，要问清楚以下四个问题：S：Situation（情况)T：Task（任务)A：Action（行为表现)R：Results（结果)，其中面试官最应该对其中哪个方面更加关注？

    A．情境

    B．任务

    C．行为表现

    D．结果


    R:Results(结果)

  • 第6题：

    在ggplot2中，自定义散点图中点的颜色所用的命令为（）

    A．scale_colour_manual()

    B．scale_linetype_manual()

    C．scale_shape_manual()

    D．scale_size_manual()


    geom_point()

相关内容