首页计算机考试Oracle认证
(多选题)

When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics.  Which two statements describe the implications of this?()

A It produces less accurate results of the comparison analysis.

B It automatically calls the SQL Tuning Advisor for recommendations.

C It shortens the time of execution and reduces the impact on system resources.

D Only the changes in the execution plan,and not performance regression,are detected.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    Examine the following command:   SQL> ALTER TABLE booking SHRINK SPACE COMPACT;   Which activity is performed when the preceding command is executed?()

    答案解析

  • (多选题)

    You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL> ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()

    答案解析

  • (单选题)

    Your Oracle Database 10g is online when you execute the following statement:        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;   What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()

    答案解析

  • (多选题)

    When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()

    答案解析

  • (单选题)

    Given: What is the result when method testIfA is invoked?()

    答案解析

  • (单选题)

    Given: What is the result when the go() method is invoked?()

    答案解析

  • (单选题)

    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified?()  

    答案解析

  • (多选题)

    When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? ()(Choose two.)

    答案解析

  • (多选题)

    When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? ()(Choose two.)

    答案解析

快考试在线搜题