1Z0-025 by Oracle Actual Free Exam Questions And Answers

Question 1

Your daily report indicating which data files need to be backed up has been misplaced. Which recovery manager command returns a report containing the files in the USER_DATA tablespace that have not been backed up within the last three days?

A. Rman>report need backup day 3 tablespace user_data;

B. Rman>report backup day 3 tablespace user_data; C.Rman>catalog backup day 3 tablespace user_data;

C. Rman> list backup day 3 tablespace user_data;

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

You have determined that one of the data files belonging to the SYSTEM tablespace is corrupt. Which complete media recovery scenario do you choose?

A. Complete recovery - mounted database.

B. You cannot recover from the corruption of a database file belonging to the SYSTEM tablespace except by going back to the last full backup.

C. Complete recovery - opened database, initially opened.

D. Complete recovery - opened database, initially closed.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

What is the correct procedure for multiplexing control files?

A. Shut down the database, edit the CONTROL_FILES parameter, copy the control file, and start up the database.

B. Shut down the database, rename the control file, edit the CONTROL_FILES parameter, and start up the database.

C. Shut down the database, edit the CONTROL_FILES parameter, issue the ALTER DATABASE MULTIPLEX CONTROLFILE command, and start up the database.

D. Shut down the database, copy the control file to trace, edit the MULTIPLEX_CONTROL_FILES parameter, and start up the database.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

In which mode is 'Closed database backups' the only backup option available?

A. NOARCHIVELOG mode.

B. READ ONLY mode.

C. ARCHIVELOG mode.

D. READ WRITE mode.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

The RMAN script is run every Sunday
Run (
Allocate channel c1 type disk
Format='/home/disk1/BACKUP/run_is_ip.bus';
backup incremental level=0 (database);
)
This RMAN script is run everyday of the week, except Sunday
Run (
Allocate channel c1 type disk
Format+ '/home/disk1/user4/BACKUP/inc_is_ip.bus'
Backup incremental level= 1cumulative (database);
)
What do these scripts do?

A. They backup the entire database everyday of the week.

B. On Sunday, they backup the system tablespace. On other days of the week, they backup all blocks changed in data file log since the previous backup.

C. On Sunday, they backup the entire database. On other days of the week, they back up all blocks changed in data file two since the previous backup.

D. On Sunday, they backup the entire database. On other days of the week, they backup all blocks changed since the previous backup.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

Consider the following scenario using incremental backups. A level 1 backup is taken on the first of the month. A level 2 backup is taken in every Sunday, and a level 3 backup is taken daily. If the database gets corrupted on the second Wednesday of the month and is lost, which scenario would restore the database completely?

A. The monthly backup (level 1) and the daily backup (level 3).

B. A base level backup (level 0) is missing and nothing can be recovered.

C. The weekly backup (level 2) and the daily backup (level 3).

D. The monthly backup (level 1), the weekly backup (level 2) and the daily backup (level5)

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

Which two items can be assigned as RMAN tag? (Choose two)

A. A tape drive.

B. A disk channel.

C. A backup set.

D. An image copy.

E. A disk drive.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

Your database is in ARCHIVELOG mode, and you want to recover from a media failure taken up to the time of failure. Which files do you need to restore?

A. The damaged files from a backup taken after the database was set in ARCHIVELOG mode.

B. The damaged files, the redo-log files, and the control files from a backup taken after the database was set in ARCHIVELOG mode.

C. The damaged files from any valid backup.

D. The damaged files and the redo log files from a backup taken after the database was set in ARCHIVELOG mode.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

To successfully recover when restoring a backup control file to a differential location what must you do?

A. Update the initialization parameter file.

B. Use the ALTER DATABASE command to rename the control file.

C. Use the ALTER SYSTEM command to rename the control file.

D. You can't do this, control files should always be stored to their original location.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

Which statement about 'cancel-based recovery' is true?

A. Recovery is stopped after the database has committed all changes up to the specified point-in-time.

B. Recovery is stopped when the database has committed all changes up to the specified system change number (SCN).

C. Recovery is stopped by entering CANCEL at the recovery prompt.

D. Recovery is stopped when the specified method of recovery (CANCEL, TIME, or CHNAGE) is completed, and the control files are recovered.

E. Recovery is stopped by pressing at <CTL-C> the recovery prompt.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle Backup and Recovery - 1Z0-025 Exam Practice Test

Contact Us

Useful Links

Latest Updated