Quiz 1z0-043

Quiz 1z0-043, Database 10g: Administration II

Which statement is true?

You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;When a backup is performed, what would be the status of this backup after seven days?

Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?

Which advisory component would you refer to, in order to determine the appropriate indexes?

Which two statements are correct in this scenario?

What is a possible reason?

Which option would you use to create a report on any corruptions found within the database?

The loss of which two types of files may require a recovery with the RESETLOGS option?

How do you achieve this objective?

You execute the following command to enable a session in resumable mode:SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;What is the impact of a timeout on the statements being suspended?