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

Thread: Help with question

  1. 03-12-2002, 03:58 PM #1
    Lani2000
    Lani2000 is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 03-12-2002, 04:08 PM #2
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134

    Lightbulb

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

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  3. 03-12-2002, 04:17 PM #3
    Lani2000
    Lani2000 is offline Junior Member
    Join Date
    Nov 2001
    Location
    Atlanta GA
    Posts
    45
    I assume the answer is A?
    Reply With Quote Reply With Quote
  4. 03-12-2002, 04:49 PM #4
    dba1
    dba1 is offline Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    A is right qnswer.
    Reply With Quote Reply With Quote
  5. 03-12-2002, 06:54 PM #5
    sumi_ocp
    sumi_ocp is offline Junior Member
    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
    Reply With Quote Reply With Quote
  6. 03-13-2002, 06:22 AM #6
    hrishy
    hrishy is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  7. 03-13-2002, 12:10 PM #7
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width