More 9i New Features Questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: More 9i New Features Questions

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    Victoria, BC Canada
    Posts
    183
    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]

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    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

  3. #3
    Join Date
    May 2001
    Location
    Victoria, BC Canada
    Posts
    183
    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

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width