1z0-063 Exam Question 81
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER flashback archive fda1 MODIFY RETENSION 2 YEAR;
What is the outcome?
You execute the following command to change the requirement:
SQL> ALTER flashback archive fda1 MODIFY RETENSION 2 YEAR;
What is the outcome?
1z0-063 Exam Question 82
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is
performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is
performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
1z0-063 Exam Question 83
Which three types of backups can be performed for a database running in NOARCHIVELOG mode?
1z0-063 Exam Question 84
Examine the list of possible steps to transport a tablespace across platforms that have the same
compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.
compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.
1z0-063 Exam Question 85
Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)