More on B&R

[D Maverick]

1. In which two situations would you have to apply redo information to a read-only tablespace? (Choose two)

A. When the tablespace being recovered has always been writeable.
B. When the tablespace being recovered is unknown to the control file.
C. When the tablespace being recovered is read-only and was read-only when the last backup occurred.
D. When the tablespace being recovered is writeable, but was read-only when the last backup occurred.
E. When the tablespace being recovered is read-only, but was writeable when the last backup occurred.

Answer: ???

[D Maverick]

2. Work is done by Recovery Manager through ____?

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

Answer: ???

[D Maverick]

3. Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true?

A. Recover manager requires a recovery catalog.
B. Recovery Manager supports multi-level incremental backups.
C. Recovery Manager is compatible with enterprise backup utility.
D. Recovery Manager only works in conjunction with a tape subsystem.

Answer: ???

[julian]

1. D,E
2. A
3. C

[gd_1976]

MAVERICK,
I GOT ALL THE ABVE 3 QUESTIONS IN MY EXAM.
aLL THE BEST.
GD_1976

[D Maverick]

Thanks Julian for the answers.

A few more questions, actually it was posted on the previous thread but somebody tried to answer it. It's my a fault, i posted a lot of questions and it's really kinda hard to read.

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

A. Update the initialization parameter file.
B. Use the ALTER SYSTM command to rename the control file.
C. Use the ALTER DATABASE command to rename the control file.
D. You can’t do this, control files should always be stored to their original location.

My Answer: A ?

5. Why would you set a data file offline when the database is in MOUNT state?

A. To minimize downtime.
B. To allow for automatic data file recovery.
C. To prevent further corruption of a damaged data file.
D. To recover it later, when database is in NOARCHIVELOG mode.

My Answer: A ?

6. What two actions occur during a checkpoint? (Choose Two)

A. Oracle performs a log switch.
B. Oracle performs a delayed block clean-out.
C. Oracle copies the online redo-log to the archive destinations.
D. Oracle flushes the dirty blocks in the database buffer cache to disk.

My Answer: C & D ?

7. If a DBA restores a read-only tablespace from a backup taken before the tablespace was made read-only, what must the DBA do next?

A. Recreate the control file.
B. Complete media recovery.
C. Make the tablespace locally-managed.
D. Alter the tablespace to become read-only.

My Answer: D ?


gd_1976, the guy who sent me these questions told me that its very similar to the real exam. he also got it from another person.

But still i don't wanna rely on Dumps. if im gonna pass an exam, its because i studied real hard and understand the topics by real well. But of course, i cant deny the fact that it helps to prepare you for the exam.

Ill be taking it on wednesday 10:30AM (GMT +8:00). i really hope to pass this exam. its been like hell preparing for it.

[Edited by D Maverick on 10-22-2001 at 11:59 AM]

[gd_1976]

Maverick,
You will not believe that 2nd set of questions which you have put was also there in my exam.
So, all the best.
I thimk you will really get thru'.
We will soon start PT forum.
Right guys - NDT & Mavrick.


Thanks to Julian, GRJIHNSON, Maverick and all others for all the help and support orivided to me to get thru the exam.


GD_!(&^

[grjohnson]

No worries gd_1976. D Maverick, question 2 was definatly on m exam, and so wre some of the others you have mentioned.

[richardana]

here are some of the answers

Question#6
Ans: A & D
Question #7
Ans:B

Richard