Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2007
    Posts
    63

    Unanswered: Pls Help me urgent - reg Commit

    Hi All,

    Have come questions ..Need urgent reply

    1. while we issue a GRANT command , will it be auto commited?
    Is it a DDL stmt ( Auto Commit )?

    2. When we issue a Roll back, will the previous transaction be roll backed and also commited?

    3. Is "MERGE" a DML command?

    4. Are the "TestKing" dumps would be useful in clearing OCA developer exam? I have prepared whollyon TestKing dumps and am having exams by tmrw. Please help me in this regard.
    Thank you

  2. #2
    Join Date
    Dec 2007
    Posts
    253
    Tell you what. You give us what you think the answers to the above are and we'll point you in the right direction.

  3. #3
    Join Date
    Apr 2007
    Posts
    63

    Reply

    I guess..GRANT would be auto comited and its a DCL data Control language
    MERGE is a DML command

  4. #4
    Join Date
    Dec 2007
    Posts
    253

    Thumbs up

    Both correct.

  5. #5
    Join Date
    Apr 2007
    Posts
    63
    Thanks a lot...

    will a Rollback coomand commits all prev transaction?

    Test king dumps would make in getting thru OCA ?

  6. #6
    Join Date
    Dec 2007
    Posts
    253
    Quote Originally Posted by prem18
    will a Rollback coomand commits all prev transaction?
    What exactly do you understand a rollback to do? What do you understand a commit to do?

    Test king dumps would make in getting thru OCA ?
    I have no idea, I'm not familiar with them. I would suggest not however, based on the questions that you have just asked.

  7. #7
    Join Date
    Apr 2007
    Posts
    63
    Sorry i was wrong in my question reg Rollback as im in a rush.
    I mean...to ask that
    whether Roll back completes a transaction or not...

  8. #8
    Join Date
    Dec 2007
    Posts
    253
    Have you read the Oracle documentation on transaction control? try here

  9. #9
    Join Date
    Apr 2007
    Posts
    63
    THAnk you..

  10. #10
    Join Date
    Dec 2007
    Posts
    253
    No probs. Good luck with your exam

Posting Permissions

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