itgle.com

The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A. statistics recommendationsB. SQL Prof

题目

The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

A. statistics recommendations

B. SQL Profile recommendations

C. Index-related recommendations

D. restructuring of SQL recommendations

相似考题

1.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

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

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

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

更多“The SQL Tuning Advisor configuration has default settings in your database instance. Which ”相关问题

  • 第1题：

    YoudiscoverthataparticulargroupofsettingsnamedUserPreferenceschanges.YouneedtostoretheUserPreferencesettingstopreventaffectingotherapplications.Whichtwoactionsshouldyouperform?()

    A.UsetheProperties.USerPreferencesobject

    B.UsetheProperties.Settings.Default.Userprefencesobject

    C.UsetheConfigurationManager.AppSettingsobjectduringruntime

    D.CreatethesettingsbyusingApplicationscope

    E.CreatethesettingsbyusingUserscope


    参考答案：B, E

  • 第2题：

    在使用SQL创建表时，下列（）用于表示主键约束。

    A．Primary Key

    B．Foreign Key

    C．Feferences

    D．Default


    Primary Key

  • 第3题：

    5、在使用SQL创建表时，下列（）用于表示主键约束。

    A．Primary Key

    B．Foreign Key

    C．Feferences

    D．Default


    Primary Key

  • 第4题：

    SQL的常用约束中，下列（）表示默认约束。

    A．primary key

    B．not null

    C．check

    D．default


    D

  • 第5题：

    建立登录用户时若不指定DEFAULT_DATABASE选项，默认数据库为master数据库。（）


    正确

  • 第6题：

    5、在使用SQL创建表时，下列（）用于表示主键约束。

    A．Primary Key

    B．Foreign Key

    C．Primary

    D．Default


    Primary Key

相关内容