Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2012
    Posts
    2

    Unanswered: please give me answers for trasaction managemt topic

    Hi Experts,

    could you please answer the following questions and save me.


    6. Julia has a lock on the savings account and Bill is trying to perform a conflicting action on the data:

    A. Bill's transaction is granted permission to perform the desired action
    B. Bill's transaction must wait until Julia's lock is released
    C. Bill's transaction must wait until Julia has read the savings account value
    D. None of the above

    7. Julia has a shared lock on the savings account and Bill is trying to perform an action requesting a shared lock on the same data:

    A. Bill's transaction is granted permission to perform the desired action
    B. Bill's transaction must wait until Julia's lock is released
    C. Bill's transaction must wait until Julia has read the savings account value
    D. None of the above

    8. Julia has an exclusive lock on the savings account and Bill is trying to perform an action requesting a shared lock on the same data:

    A. Bill's transaction is granted permission to perform the desired action
    B. Bill's transaction must wait until Julia's lock is released
    C. Bill's transaction must wait until Julia has read the savings account value
    D. None of the above

    9. Which of the following will cause a deadlock?

    A. Transaction T1 requests an exclusive lock on data A at the same time as transaction T2
    B. Transaction T1 places an exclusive lock on data A, then transaction T2 requests a shared lock on data A
    C. Transaction T1 places an exclusive lock on data A, then requests one on data B. Simultaneously, transaction T2 places an exclusive lock on data B, then requests one on data A
    D. Transaction T1 and T2 modify data A without any lock

    10. In the two-phase locking protocol:

    A. A transaction only acquires a lock after the previously acquired lock has been released
    B. A transaction acquires locks as needed. After it starts releasing locks, it does not acquire new locks
    C. A transaction acquires all needed locks at once, then releases them after completion
    D. The transaction locks the full database, then releases the locks

    11. Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode. The transaction terminates abnormally after 10 rows have been updated in the database (and the normal operations have taken place on the log). What should the recovery procedure perform to make sure the transaction completes as desired?

    A. Redo
    B. Redo followed by execution of the transaction again
    C. Undo
    D. Undo followed by execution of the transaction again

    12. Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the deferred update mode. The transaction terminates abnormally after the new values of 10 rows have been written to the log. What should the recovery procedure perform to make sure the transaction completes as desired?

    A. Execute the transaction again
    B. Redo followed by execution of the transaction again
    C. Undo
    D. Undo followed by execution of the transaction again

    13. Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode and completes before a checkpoint. The system crashes after the checkpoint. What should the recovery procedure perform to make sure the transaction completes as desired?

    A. Nothing
    B. Redo followed by execution of the transaction again
    C. Undo
    D. Undo followed by execution of the transaction again

    14. Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode and completes after a checkpoint but before a system failure. The system crashes after the checkpoint. What should the recovery procedure perform to make sure the transaction completes as desired?

    A. Nothing
    B. Redo forward from checkpoint
    C. Undo
    D. Undo followed by execution of the transaction again


    Thanks,
    chitti
    Last edited by chitti2012; 11-28-12 at 04:00. Reason: some i did earlier

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    We don't do your homework. Especially as you have shown no sign whatsover that you tried for yourself.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Nov 2012
    Posts
    2
    shammat, it consists of total 50 questions I have done sql coding related part my own.
    but I am confusing a lot in this tranaction theoritical part
    Last edited by chitti2012; 11-28-12 at 04:25.

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    It would be pointless giving you the answers, as you will have learnt nothing, and you will be in the same situation as you are now when the next question about locking rears its ugly little head. Far better that you read up & try to understand, then ask if there's a specific point that you don't understand. This article might help you understand locking a bit better (there's plenty more similar articles out there as well):

    The Arup Nanda Blog: How Oracle Locking Works
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Please use the search function on the forum. These questions have already been answered in this thread:

    http://www.dbforums.com/microsoft-sq...n-teasers.html

Tags for this 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
  •