Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
DECLARE report clob;
BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
Which statement describes the effect of the execution of the above PL/SQL block?
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?
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.)
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)
In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:
SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales
GROUP BY sale_category;
Where would the result of this query be stored?
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ‘ora_%t_%s_%r.log’.
Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?