exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 114 discussion

Actual exam question from Oracle's 1z0-062
Question #: 114
Topic #: 1
[All 1z0-062 Questions]

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
/mydir/rman_change_track.f;
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)

  • A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  • B. The change tracking file must always be backed up when you perform a full database backup.
  • C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
  • D. More than one database block may be read by an incremental backup for a change made to a single block.
  • E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed
Show Suggested Answer Hide Answer
Suggested Answer: ADE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Ray520
3 years, 1 month ago
reference: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm#:~:text=A%20differential%20backup%2C%20which%20backs,incremental%20backup%20at%20level%200 "Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to the checkpoint SCN of the parent incremental backup. If the SCN in the input data block is greater than or equal to the checkpoint SCN of the parent, then RMAN copies the block." "Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up."
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago