Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • PrintPrint
    Share this Page URL
    Help

    Self Test Answers

    Monitor and Resolve Blocks and Deadlocks

    1. B. With deadlocks there will usually only be one user impacted and an error message will usually be generated quickly (error 1205). Blocking is often seen when one or more users’ processes hang and there is no immediate error message or it is a message other than 1205.

    A, C, and D are incorrect.

    2. A. A shared lock will usually be acquired for a read-only operation.

    B, C, and D are incorrect.

    3. B. Exclusive locks are acquired for modification operations.

    A, C, and D are incorrect.

    4. A. A 1205 error indicates that a deadlock has occurred.

    B, C, and D are incorrect.

    5. C. The highest priority you can set for the DEADLOCK_PRIORITY setting is either HIGH or 10.

    A, B, and D are incorrect.


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial