Online Access Free 1Z0-025 Practice Test

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

• A.Recovery is stopped when the specified method of recovery (CANCEL, TIME, or CHANGE)
• B.Recovery is stopped after the database has committed all changes up to the specified point of time.
• C.Recovery is stopped by entering CANCEL at the recovery prompt.
• D.Recovery is stopped by pressing at <CTL-C> the recovery prompt.
• E.Recovery is stopped when the database has committed all changes up to the specified system changes number (SCN).

Work is done by recovery manager through ____?

• A.Operating system commands.
• B.Operating system scripts.
• C.PL/SQL packages.
• D.External procedures.

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

• A.The data file is part of a read-only tablespace.
• B.The data file is in backup mode.
• C.The data file is corrupted.
• D.The data file is locally managed.

You have been informed that the ORDER table was dropped two days ago. It is unwise to
perform an incomplete recovery of this database; therefore, your only option is to
perform tablespace point-in-time recovery.
What are two ways this can be done in Oracle8i?

• A.Create and recover a clone database and export the primary database into this new database.
• B.Create and recover the database on another machine and use the transportable tablespace option.
• C.Recover only the files for the tablespace that contains the ORDER table.
• D.Create and recover a clone database, export the table from the clone database, then import it into the primary database.

What are benefits of putting the database in ARCHIVELOG mode? (Choose two)

• A.The database can be backed up while online.
• B.It guarantees recovery to the time of failure.
• C.Checksums are performing on all archived files.
• D.All pending transactions are committed.
• E.Backups are done automatically.