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？（）

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（）

多选题查看答案