Just a moment ago passed the IZ0-025. The previous dump for 025 here in this site is pretty closed to the
real thing. Together with the questions I found from another web-site (posted below in this message), it covers about 70% of my real exam. I didn't
score very highly so do check the answer. Again, The official training kit from Oracle is nearly a must to have because most of the exam questions
should be directly from there. Do pay special attention to recovery by using RMAN (incomplete & complete). There were several "confusing"
questions about this in my real exam.

So far, I found 026 the easiest, and then 001, 025, 023. Think 024 should be the most difficult one... 4
down - 1 more to go !!

Good luck,
Hoi - HK
(CCNA/DA,CNA/E,MCSD/DBA/SE/SA)

1. (Similar Question seen 69 times, last seen on
7/10/2002)

A user has received an ORA-1578 error message indicating datablock corruption of a specific file. It has been determined that the
data
contained in the corrupted files can be lost with minimal consequences. How should the uncorrupted rows be recovered?

A. Perform Table Only
recovery in Recovery Manager.
B. Issue the ALTER TABLE REMOVE command.
C. Delete all rows from the table and then issue a rollback.
D. Select
All rows below and above the corrupted block and insert them into a new table.

Answer: D

2. (Similar Question seen 32 times, last seen on
7/10/2002)

If an invalid checksum is detected on a redolog group member prior to
its being archived, what will happen?

A. The redolog group
member is archived.
B. The ARCH process hangs.
C. The archive returns a fatal error.
D. No archive occurs and an error is written to the
ALERT_LOG file.

Answer: D

3. (Similar Question seen 27 times, last seen on 7/10/2002)

You use Backup Manager because it is easy to access.
Why is it easy to access?

A. It can be opened from SQL plus.
B. It is NDS-compatible.
C. It is operating system independent.
D. It is not
incorporated into Oracle Enterprise Manager.

Answer: C

4. (Similar Question seen 24 times, last seen on 7/10/2002)

You have just changed
the mode of your database to ARCHIVELOG. What table must be viewed to view mode information?

A. V$ARCHIVELOG
B. V$DATABASE
C. V$RECOVER
D.
V$INSTANCE

Answer: B

5. (Similar Question seen 29 times, last seen on 7/10/2002)

To use Recovery Manager to recover a database, the
database ______.

A. Must include all archived redolog files.
B. Must have been taken or registered using RMAN.
C. Must include the backed-up
control files.
D. Have online datafiles before they can be restored using RMAN.

Answer: B

6. (Similar Question seen 44 times, last seen on
7/10/2002)

A datafile is not synchronized. If the database is to continue running
without errors, the file must be in which type of tablespace
along with
other database files?

A. ONLINE
B. READ-WRITE
C. TEMPORARY
D. READ-ONLY

Answer: D

7. (Similar Question seen 26 times,
last seen on 7/10/2002)

If the checksum for each member in a redolog group is invalid, what will
happen during archiving?

A. The archive
process will reset.
B. The database will hang
C. The archive process will switch to the next redolog group and continue the backup.
D. The
redolog process will abort and the database will continue until the problem has been resolved.

Answer: B

8. (Similar Question seen 27 times,
last seen on 7/10/2002)

In which two files is the sequence number of the current redolog file
recorded? (choose 2)

A. Most recent archived
log file
B. Parameter file
C. Control file
D. System tablespace datafile

Answer: C, D

9. (Similar Question seen 47 times, last seen on
7/10/2002)

A data file that belongs to the SYSTEM tablespace is corrupted.
You perform a data file recovery, which action must you take
to
perform this recovery?

A. take the datafile belongs to the SYSTEM tablespace offline
B. You can't perform datafile recovery since this
file belongs to the SYSTEM tablspace.
C. Take the SYSTEM tablespace offline.
D. Export the entire SYSTEM tablespace.

Answer: B

10.
(Similar Question seen 24 times, last seen on 7/10/2002)

You restore the backup copies of the corrupted data files, which
command will begin the
full database recovery?

A. RECOVER tablespace.
B. RECOVER datafile
C. RECOVER database
D. RECOVER database complete

Answer: C

11.
(Similar Question seen 19 times, last seen on 7/10/2002)

You are the DBA of a database that is used by investment strategy
analysis. The loss of
transaction activities would be disastrous.
Which step would you include as part of your backup and recovery
strategy:

A. Manually backup redo
log files.
B. Automatically archive the redo log files
C. Automatically archive the database
D. make frequent Cold Backups

Answer:
B

12. (Similar Question seen 23 times, last seen on 7/10/2002)

Before determining a backup & recovery strategy for your database
which action
should you take to ensure the appropriate strategy?

A. meet with management to determine their tradeoffs involved in their expections of system
availability.
B. Meet with end users to determine their expectations for data availability
C. Determine how many redo log files you expect to be
created on a daily basis
D. Determine how many Checkpoints will be requested to allow the max. availability

Answer: A

13. (Similar Question
seen 28 times, last seen on 7/10/2002)

Your database is not in ARCHIVELOG mode. A file has been damaged
and you now must apply your backup and
recovery strategy. Which step
should be your first?

A. Shut down the database, if it is not already
B. Startup the database
C. Restore most
recent full online backup
D. Alter database to ARCHIVELOG mode

Answer: A

14. (Similar Question seen 19 times, last seen on
7/10/2002)

Which characteristic describes an incomplete recovery?

A. Minimized the amount of work lost
B. Recovers to the state just prior
to the current time
C. Can be performed while the database is still available to users
D. Reconstructs the database to a point in the Past *


Answer: D

15. (Similar Question seen 19 times, last seen on 7/10/2002)

You have decided to perform an incomplete recovery of database,
which
action must you take to accomplish this type of recovery.

A. restrore copy of control file that was backuped prior to the current time.

B. Issue the incomplete recover command after restore all backup datafiles.
C. None
D. Halt recovery operation prior to reaching the current
time.

Answer: D

16. (Similar Question seen 18 times, last seen on 7/10/2002)

When recovery a damaged datafile, you determined that backup
file
requires redo log entries to be applied. Which action must you perform to
complete recovery.

A. Alter mode of database to archivelog.
B.
Alter the mode of database to noarchivelog.
C. Identify the necessary redo log files that been created since last backup.
D. Identify checkpoint
information, and apply this checkpoint to appropriate data file.

Answer: C

17. (Similar Question seen 19 times, last seen on
7/10/2002)

The database has to be run 24 hr/day and 7 days/week. If you
want to export the whole database with Export utility,
what should you
consider?

A. concurrent transaction will suffer
B. the database being exported will be locked
C. constraint may cause problem

Answer:
A

18. (Similar Question seen 21 times, last seen on 7/10/2002)

The recovery operation you are preparing include read-only
tablespaces. Which
command can you issue to get a listing
of the commands needed to recover this database?

A. ALTER TABLESPACE
B. CREATE CONTROL FILE
C. ALTER
DATABASE RENAME
D. ALTER DATABASE BACKUP CONTROLFILE TO TRACE

Answer: D

19. (Similar Question seen 23 times, last seen on 7/10/2002)

The
PROD database is running in NOARCHIVELOG mode and a media
failure occurs. The disk drive holding one of the detafile
cannot be replaced
immediately and you have moved the datafile
to another drive. Which command would you issue to reflect
this physical change in the databse?

A.
ALTER DATAFILE RENAME
B. ALTER SYSTEM RENAME FILE
C. ALTER DATABASE RENAME FILE
D. ALTER TABLESPACE RENAME FILE

Answer: C

20. (Similar
Question seen 22 times, last seen on 7/9/2002)

To recover the database using the available archived redo log
files. Which two tasks you need to
perform? (Choose two)

A. Set AUTORECOVERY on
B. Set recover all on
C. Recover all database
D. Recover database
E. Set autorecover
database on
F. Recover

Answer: A, D

---