Backup and Recovery - 1Z0-025 Exam Practice Test

Question 1

You perform an incomplete recovery using RMAN. You write the following script:
RUN{
SET UNTIL TIME='yyyy-nm-dd:hh:mi:ss';
RESTORE DATABASE;
RESTORE DATABASE;
SQL"alter database open resetlogs";
Which command is missing?

A. SET LIMIT CHANNEL cname KBYTES 4194304

B. ALLOCATE CHANNEL cname TYPE DISK;

C. RESYNC CATALOG;

D. RELEASE CHANNEL;

Correct Answer: B

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

Question 2

In which situation would you need to create a new control file for an existing database?

A. When all redo-log files are lost.

B. When the name of the parameter file needs to be changed.

C. When MAXLOGMEMBERS needs to be changed.

D. When RECOVERY_PARALLELISM needs to be changed.

Correct Answer: C

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

Question 3

You have just created a script in recovery Manager. After noticing an error in the
script, you decide to recreate it.
Which command replaces the stored script in the recovery catalog?

A. REPLACE SCRIPT

B. RECREATE SCRIPT

C. RECREATE_SCRIPT

D. REPLACE_SCRIPT

Correct Answer: A

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

Question 4

You should issue a backup of the control file after issuing which command?

A. CREATE TABLESPACE

B. CREATE TABLE

C. CREATE ROLLBACK SEGMENT

D. ALTER TABLE

Correct Answer: A

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

Question 5

What is the correct procedure for multiplexing existing online redo logs?

A. Issue the ALTER DATABASE. . . ADD LOGFILE GROUP command.

B. Shut down the database, copy the online redo-log, and start up the database.

C. Shut down the database, copy the online redo-log, edit the REDO_LOG_FILES parameter, and start up the database.

D. Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command.

Correct Answer: D

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

Question 6

Which two tasks can a DBA perform using the export/import facility? (Choose two)

A. Archive historical data.

B. Recreate the control file.

C. Transport tablespaces between databases.

D. Examine log files.

E. Make a logical backup of the rollback segment tablespace.

Correct Answer: A,C

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

Question 7

Which two types of data files can be considered non-essential? (Choose two)

A. Data files belonging to a temporary tablespace.

B. Data files belonging to an application data tablespace.

C. Data files belonging to a SYSTEM tablespace.

D. Data files belonging to a rollback segment tablespace.

E. Data files belonging to an index tablespace.

F. Data files belonging to a lost tablespace.

Correct Answer: C,D

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

Question 8

What are two benefits of using RMAN with a catalog? (Choose two)

A. You can copy the redo-log history into the control file.

B. You can maintain records of backup and recovery operations.

C. You can synchronize the recovery catalog and the target database.

D. You can store scripts for backup and recovery operations.

E. You can register the target database with recovery catalog.

Correct Answer: B,D

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

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

Latest Update

Useful Links

Contact Us