Help with question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Help with question

  1. #1
    Join Date
    Nov 2001
    Location
    Atlanta GA
    Posts
    45
    Which of the following commands does not update the control file?
    a.Truncate table
    b.Recover from cold backup
    c.Instance recovery
    d.Recover from hot backup

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131

    Lightbulb

    Let me give you a hint, only one of those is a command.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Nov 2001
    Location
    Atlanta GA
    Posts
    45
    I assume the answer is A?

  4. #4
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    A is right qnswer.

  5. #5
    Join Date
    Mar 2002
    Posts
    60
    That was a tricky question.. Only A is a valid command..

    so A is the right answer..

    cheers to MR. HANKY...I learned from this..

    thanks

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

    Talking

    Hi

    The concept is somethin like this...the control file stores the physical structure of the database.truncating a table does not change the physical structure and hence the naswer is A.

    regards
    Hrishy

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by hrishy
    Hi

    The concept is somethin like this...the control file stores the physical structure of the database.truncating a table does not change the physical structure and hence the naswer is A.

    regards
    Hrishy
    Exactly correct, I would not count on my hint on the real exam. It just struck me that in this example only one answer was a valid "COMMAND".

    I hope you have as much luck on the exam, but I doubt it.

    MH
    I remember when this place was cool.

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