Backup and Recovery (1Z0-025) Free Practice Test

Question 1

When creating a standby database, which files must be transferred to the standby server?

A. The database backup and the archived redo-log files.

B. The standby control file, the database backup, and the archived redo-log files.

C. The database backup and the online redo-log files.

D. The standby control file, the database backup, and the online redo-log files.

Correct Answer: B

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

Question 2

Which command is used to allow RMAN to store a group of commands in the recovery catalog?

A. CREATE SCRIPT

B. ADD BACKUP SCRIPT

C. ADD SCRIPT

D. CREATE COMMAND

Correct Answer: A

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

Question 3

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 entire database. On other days of the week, they back up all blocks changed in data file two since the previous backup.

C. 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.

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

Correct Answer: D

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

Question 4

What is the advantage of managed recovery mode?

A. Prompts for applying the next available redo logs suppressed.

B. The standby database automatically applies the archived redo log when the files become available.

C. During recovery, most common DBA errors can be avoided.

D. The primary database automatically ships archived redo log files to the standby server.

Correct Answer: B

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

Question 5

During an opened database backup, a power failure occurs. Which SQL statement do you issue to resolve this situation after mounting the database?

A. ALTER TABLESPACE name DATAFILE n END BACKUP

B. ALTER DATABASE DATAFILE n END BACKUP

C. ALTER DATABASE OPEN RESETLOGS

D. ALTER DATABASE n END BACKUP

Correct Answer: B

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

Question 6

In the view V$DATAFILE_HEADER, what does value 'YES' in the 'FUZZY' column as specified?

A. The data file is corrupted.

B. The data file is in backup mode.

C. The data file is locally managed.

D. The data file is part of a read-only tablespace.

Correct Answer: B

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

Question 7

When the status of the tablespace moves from read-only to read-write, which two events occur? (Choose two)

A. Oracle automatically means the file for backup.

B. All objects in the tablespace are checked for integrity.

C. Redo-log switch must take place.

D. Normal checkpoints on the file now occur.

E. The DBWn process writes to the data files of the tablespace.

Correct Answer: C,D

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

Question 8

Which two statements regarding the use of Recovery manager with a database in NOARCHIVELOG mode are true? (Choose two)

A. For full recovery of a database not in NOARCHIVELOG mode using recovery manager, a current recovery catalog in mandatory.

B. Recovery manager cannot be used with a database running in NOARCHIVELOG mode.

C. The target database must be in MOUNT mode for restriction of data files.

D. A DBA can only restore using RMAN if the backups were taken or registered with recovery manager.

E. To restore to a previous point in time using recovery manager, the command PARTIAL RECOVER must be included in the RMAN script.

Correct Answer: C,D

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

Question 9

When using recover manager without a catalog, the connection to the target database ______?

A. Must be specified using a Net8 service name.

B. Must be a local connection.

C. Must be a remote connection.

D. Can be a local or a remote connection.

Correct Answer: D

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

Question 10

Given the RMAN script:
run(
allocation channel t2 type 'SET_TAPE'
backup filesperset 3
format '/disk1/backup/ar_%t_%s_%p'
(Archivelog from logseq*1056 until logseq*1056
thread*1 delete input):
)
What does this script do?

A. Backup three archived logs into one backup set.

B. Backup three data files into one backup set.

C. Backup one archived log into one backup piece.

D. Backup three archived logs into three backup pieces.

E. Backup one archived log into three backup set.

F. Backup one data file into one backup set.

Correct Answer: D

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

Welcome to TestSimulate

Oracle Backup and Recovery (1Z0-025) Free Practice Test