Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

• A. The database must be running in ARCHIVELOG mode.
• B. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
• C. No special setup is required, and the feature is enabled by default.
• D. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
• E. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)

• A. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
• B. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
• C. GRANT EXECUTE ON dbms_flashback TO scott;
• D. GRANT SELECT any transaction TO scott;
• E. ALTER DATABASE FLASHBACK ON;
• F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Which of the following statements is true regarding implementing a Flashback Table
recovery?

• A. If a significant number of changes have been made to the table, row movement must be enabled.
• B. An SCN is never used to perform a Flashback Table recovery.
• C. The tablespace must be offline before performing a Flashback Table recovery.
• D. Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.
Which statement about performing user-managed backups in a 24x7 environment is true?

• A. To back up a tablespace, it must be in backup mode
• B. You must have change tracking enabled in your database
• C. To back up a tablespace, it must first be taken offline
• D. Your database must be running in NOARCHIVELOG mode

On the development database rac0, there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each. An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2. Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

• A. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 NORMAL REDUNDANCY FAILGROUP DATA1A DISK '/dev/raw/raw3' FAILGROUP DATA1B DISK '/dev/raw/raw4';ALTER DISKGROUP DATA1 UNDROP DATA1_0001;
• B. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 HIGH REDUNDANCY FAILGROUP DATA1A DISK '/dev/raw/raw3' FAILGROUP DATA1B DISK '/dev/raw/raw4;'ALTER DISKGROUP DATA1 UNDROP DISKS;
• C. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 NORMAL REDUNDANCY FAILGROUP DATA1A DISK '/dev/raw/raw3' FAILGROUP DATA1B DISK '/dev/raw/raw4';ALTER DISKGROUP DATA1 UNDROP DISKS;
• D. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001 ADD DISK GROUP DATA2 NORMAL REDUNDANCY FAILGROUP DATA1A DISK '/dev/raw/raw3' FAILGROUP DATA1B DISK '/dev/raw/raw4';ALTER DISKGROUP DATA1 UNDROP DISKS;