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
正确答案
答案解析
相似试题
(单选题)
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()