1Z0-053 Free Practice Test

- (Topic 3)
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).
Identify two scenarios is which you must have a recovery catalog. (Choose two.)

1. A. To store the backup information of multiple database
2. B. To restrict the amount of space that is used by the backups
3. C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
4. D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

Correct Answer: AD

- (Topic 8)
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D
5. E. Option E

Correct Answer: E

- (Topic 10)
Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable the block change tracking, after the incremental level 0 backup you issued the following command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/
rman_change_track.f';
To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which two statements are true in the above situation? (Choose two.)

1. A. The block change tracking data will be used only from the next incremental 0 backup.
2. B. The incremental backup will use change tracking data for accomplishing the backup.
3. C. The incremental backup will not use change tracking data for accomplishing the backup.
4. D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

Correct Answer: AC

- (Topic 2)
What will be the result of the following configuration?
Log_archive_dest_1 = 'location=c:oraclearchmydb' Log_archive_dest_2 = 'location=z:oraclearchmydb'

1. A. An error will occur during database startup because the second parameter is not valid.
2. B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
3. C. Archived redo logs will be created in two different locations by the ARCH process.
4. D. Archived redo logs will be created in two different locations by the LGWR process.
5. E. Neither parameter setting is valid, so the database will not start up.

Correct Answer: C

- (Topic 11)
Which pseudocolumn could you use to identify a unique row in a Flashback Versions
Query?

1. A. XID
2. B. VERSIONS_PK
3. C. VERSIONS_XID
4. D. VERSIONS_UNIQUE

Correct Answer: C