Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)A. A single SQL statement provided by a userB. An existing SQL Tuning Set (STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement i

题目
Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources

相似考题

1.SQL中,与“NOTIN”等价的操作符是()。A、=SOMEB、=ALLC、SOMED、ALL

2.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

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

4.在SQL中，集合成员算术比较操作“元组＜＞ALL(集合)”中的“＜＞ALL”的等价操作符是 ______。A．NOT INB．INC．＜＞SOMED．=SOME

更多“Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.) ”相关问题

  • 第1题：

    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

  • 第2题：

    在SQL中，集合成员算术比较操作“元组<>ALL(集合)”中的“<>ALL”的等价操作符是（ ）。

    A. NOT IN

    B. IN

    C. <>SOME

    D. =SOME


    正确答案：A
    在SQL中，集合成员算术比较操作“元组<>ALL(集合)”中的“<>ALL”的含义是该元组与集合中的任何一个元组都不相等，也就是该元组并不在该集合中，因此其等价的操作符应该是“NOT IN”。

  • 第3题：

    SQL子查询使用的量词包括______。

    A．EXISTS

    B．ANY

    C．SOME

    D．ALL


    ANY;SOME;ALL

  • 第4题：

    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

  • 第5题：

    在SQL中，集合成员算术比较操作“元组＜＞ALL(集合)”中的“＜＞ALL”的等价操作符是( )。

    A．NOT IN

    B．IN

    C．＜＞SOME

    D．=SOME


    正确答案：A

  • 第6题：

    在SQL的嵌套查询中，如何区分谓词ANY和ALL，请用实例进行说明。


    对

相关内容