Online Access Free 11gocmu Exam Questions

When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

• A.COMPACT
• B.CASCADE
• C.INCLUDING DEPENDENCIES
• D.INCLUDING DEPENDENCIES CASCADE
• E.None of the above

Examine the following command that is used to duplicate a database on the same host:
RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }
Which two statements describe the effect after the database is duplicated successfully? (Choose two)

• A.The read-only tablespaces in the target database are changed to online after duplication
• B.The read-only tablespaces in the target database are not defined in the new database
• C.The data files of the read-only tablespaces in the target database are not duplicated
• D.The read-only tablespaces in the target database are still defined in new the database
• E.The data files of the read-only tablespaces in the target database get duplicated

Which statement is true regarding the VALIDATE DATABASE command?

• A.It checks for block corruption in the valid backups of the database.
• B.It checks for only those corrupted blocks that are associated with data files.
• C.It checks the database for both intrablock and interblock corruptions.
• D.It checks the database for intrablock corruptions only.

Which two statements about workload capture and replay operations are true? (Choose two.)

• A.Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
• B.The clients must be created manually on the test machines to perform more realistic testing.
• C.Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
• D.The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?

• A.The datafiles are in STANDBY mode.
• B.The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
• C.The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
• D.The datafiles have an OFFLINE status.
• E.The datafiles have an ONLINE status.