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…

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.) A. generating the SQL profile B. testing and accepting the SQL profile C. generating a list of candidate SQLs for…

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? A. The…

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? A. Data Pump Export and Import B. conventional export and import C. the CONVERT…

Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.) A. Supplemental log must be enabled. B. Supplemental log must be enabled for the primary key. C. Undo retention guarantee for the database must be…

View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident? A. The DBA is working on the incident and prefers that the incident be kept in the ADR. B. The…

Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000 DECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report); END; Which statement describes the effect of the execution of the above PL/SQL block? A. The plan baselines are verified with…