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

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement,which recommends that you accept the profile.  Which statement is true when you accept the suggested SQL profile?()  

    答案解析

  • (多选题)

    Which two statements are true regarding the starting of the database instance using the following command?() SQL>STARTUP UPGRADE  

    答案解析

  • (单选题)

    Examine the following ALTER command:   SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;   What is the purpose of the command?()  

    答案解析

  • (单选题)

    Which statement is true about loading data using the conventional path of SQL*Loader()

    答案解析

  • (单选题)

    A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition.  What happens to the PL/SQL procedure after the online table redefinition?()

    答案解析

  • (多选题)

    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process?()

    答案解析

  • (单选题)

    Given that the current directory is empty, and that the user has read and write privileges to the currentdirectory, and the following: Which statement is true?()

    答案解析

  • (单选题)

    You issued the following statement:   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n;   What will be the result of issuing the above statement?()

    答案解析

  • (多选题)

    You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command()

    答案解析

快考试在线搜题