Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000DECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();DBMS_OUTPUT.PUT_LINE(report); END; Which statement describes the effect of theexecution of the above PL/SQL block?
View the Exhibit to examine the details for an incident. Which statement is true regardingthe status of the incident?
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 withoutaffecting the changes made by other transactions?
When executing a SQL workload, you choose to generate execution plans only, withoutcollecting execution statistics. Which two statements describe the implications of this?(Choose two.)
While deploying a new application module, the software vendor ships the applicationsoftware 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 theinitialization parameter file. You issued the following command: SQL>SELECT /*+RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUP BYsale_category; Where would the result of this query be stored?
Identify the activities performed as part of the Automatic SQL Tuning process in themaintenance window? (Choose all that apply.)
You performed an incomplete recovery and opened the database with the RESETLOGSoption. The LOG_ARCHIVE_FORMAT parameter is set to ‘ora_%t_%s_%r.log’. Whichstatement regarding the archived redo log files, created in an earlier incarnation of thedatabase, is true?