You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours: ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER…

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 two are the prerequisites to enable Flashback Data Archive? (Choose two.) A. Undo retention guarantee must be enabled. B. Database must be running in archivelog mode. C. Automatic undo management must be enabled. D. The tablespace on which the…

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP;…

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.) A. fixed tables B. heap tables C. external tables D. temporary tables E. Index-Organized Tables (IOTs)

Which two statements about the SQL Management Base (SMB) are true? (Choose two.) A. It contains only SQL profiles generated by SQL Tuning Advisor. B. It stores plans generated by the optimizer using a stored outline. C. It is part…

Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)? A. The incident metadata is purged when the problem is resolved and the DBA closes the SR. B. The incident files and…

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the…

You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ‘/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ”; Which statement regarding the above command…

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQL statement in a SQL Tuning Set? (Choose two.)…