1Z0-063 Free Practice Test

- (Exam Topic 1)
Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the RESETLOGS option.
6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

1. A. 1, 3, 4, 5
2. B. 6, 3, 4, 5
3. C. 2, 3, 4, 5
4. D. 6, 4, 3, 5

Correct Answer: C

- (Exam Topic 2)
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

1. A. Block change tracking must be enabled before executing this command.
2. B. The database must be running in ARCHIVELOG mode for the successful execution of this command.
3. C. A complete database backup must exist before executing this command.
4. D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
5. E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Correct Answer: D

- (Exam Topic 1)
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

1. A. You cannot export data from a remote database.
2. B. You can rename tables during import.
3. C. You can overwrite existing dump files during export.
4. D. You can compress data but not metadata during export.

Correct Answer: BC

- (Exam Topic 1)
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

1. A. Corrupted blocks, if any, are repaired in the backup created.
2. B. Only those data files that have corrupted blocks are backed up.
3. C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
4. D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Correct Answer: D

- (Exam Topic 1)
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

1. A. The backup must be performed in MOUNT state.
2. B. The tablespace must be taken offline.
3. C. All files must be backed up as backup sets.
4. D. The database must be backed up as an image copy.

Correct Answer: C