To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manu

题目
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()

A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.

B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.

C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.

D. Either B or C

相似考题

1.（36）为了考虑安全性，每个部门的领导只能存取本部门员工的档案，为此DBA应创建相应的（ ）。A）视图（view）B）索引（index）C）游标（cursor）D）表（table）

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
更多“To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?() ”相关问题

  • 第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题：

    (36）为了考虑安全性，每个部门的领导只能存取本部门员工的档案，为此DBA 应创建相应的

    A）表( table)

    B）索引（index）

    C）视图( view)

    D）游标（cursor )


    正确答案：C

  • 第3题：

    (23 ）为了提高查询速度，则 DBA 应创建相应的

    A ）视图（ View ）

    B ）索引（ Index ）

    C) 游标（ Cursor ）

    D) 基本表（ Table ）


    正确答案：B

  • 第4题：

    当创建了过程,可以在SQL*Plus中使用()执行之。

    A.exec函数

    B.SET

    C.COMMIT

    D.TAKE


    参考答案：A

  • 第5题：

    （ 22 ）如果只允许学生查看自己所选课程的信息和分数，则 DBA 应创建相应的

    A ）视图（ View ）

    B ）索引（ Index ）

    C) 游标（ Cursor ）

    D ）基本表（ Table ）


    正确答案：A

  • 第6题：

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

    A．scale_colour_manual()

    B．scale_linetype_manual()

    C．scale_shape_manual()

    D．scale_size_manual()


    geom_point()

相关内容