You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME…

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files? A. TEST_TBS is a…

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the…

Which setting enables the baselines by default in Oracle Database 11g? A. setting the STATISTICS_LEVEL parameter to TYPICAL B. adding filters to the Automatic Database Diagnostic Monitor (ADDM) C. enabling Automated Maintenance Task using Oracle Enterprise Manager D. setting the…

View the Exhibit for the object interdependency diagram. The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure. GET_DATA is called in the CHECK_DATA function. A new column PROD_QTY is added to the…

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.) A. ADR diagnostic files B. all the optimizer statistics C. initialization parameter settings D. PL/SQL…

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression…

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions? A. point-in-time recovery B. execute the ROLLBACK command with transaction number C. flashback the database to before the…

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.) A. It produces less accurate results of the comparison analysis. B. It automatically calls…

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.) A. The plan baselines can be evolved…