More 9i New Features Questions

[gee]

I am running into difference between study material and practice questions as follows:

Hash Partitiion, was it introduced in oracle 8i or 9i ... practice question picks 9i?

When storing the time zone displacement (or offset) does it require extra bytes ... study material says yes, practice question says no?

You maintain a primary and standby database. You want to configure your system for no-data-loss. No data divergence is acceptable.

Which data availability mode should you use?

A. Rapid protection
B. Instance protection
C. Delayed protection
D. Guaranteed protection

My anwser was B. selftest was D.

Gee,
OCP 8i DBA
MCSE

[Edited by gee on 05-30-2002 at 12:56 AM]

[hrishy]

Hi

well my answers are as below.

Hash Partitiion, was it introduced in oracle 8i or 9i ... practice question picks 9i?

Hash partitioning was introduced in 8i.
List Partitioning was introduced in 9i


b)
Guaranteed Protection

Basically, this is the “no data divergence” mode, and is therefore the strictest mode in which to operate Data Guard. It, of course, guarantees that the Standby is able to be brought into complete synchronism with the primary database, and therefore also implies that in the event of the primary database dying, there is absolutely no data loss.

so self test is correct

the other one i dont have any idea.sorry.

regards
Hrishy

[gee]

Guaranteed Protection

Hrishy I see it now ... I was reading the question as data divergence is acceptable ... boy can't even use drinking as an excuse on this one.

Thanks,
Gee

[hrishy]

Hello Gee

I would love to hear from you and your experiences after you complete the upgarde exam.Best of luck dude ;-D

regards
Hrishy