Ask a Question

If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.

in Education by
If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks. (a) Intention lock modes (b) Intention-shared-exclusive mode (c) Intention-exclusive (IX) mode (d) Intention-shared (IS) mode The question was posed to me in exam. The above asked question is from Multiple Granularity in portion Concurrency Control of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Right answer is (c) Intention-exclusive (IX) mode Easiest explanation - There is an intention mode associated with shared mode, and there is one with an exclusive mode.

Related questions

0 votes
Q: If a node is locked in ______________ the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.
    If a node is locked in ______________ the subtree rooted by that node is locked explicitly in shared ... Granularity topic in division Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
    If a node is locked in __________ explicit locking is being done at a lower level of the tree, but ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
    If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If needed to split a node or coalesce it with its siblings, or redistribute key values between siblings, the crabbing protocol locks the parent of the node in ____________ mode.
    If needed to split a node or coalesce it with its siblings, or redistribute key values between siblings, ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.
    If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ... Based Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: In crabbing protocol to inset or delete a key value the leaf node has to be locked in ___________ mode.
    In crabbing protocol to inset or delete a key value the leaf node has to be locked in ___________ ... Index Structures topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
    If an entity set is a lower-level entity set in more than one ISA relationship, then the entity ... in section Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If A and B be mutually exclusive events associated with a random experiment such that P (A) = 0.4 and P (B) = 0.5, then find:
    If A and B be mutually exclusive events associated with a random experiment such that P (A) = 0.4 and P (B) = 0.5 ... (iv) P(A ∩ bar B) Select the correct answer from above options...
asked Nov 22, 2021 in Education by JackTerrance
0 votes
Q: If A and B are mutually exclusive events with `P(B) ne 1, " then " P(A//overline(B))`=
    If A and B are mutually exclusive events with P(B)≠1, then P(A/ ˉ B )= A. 1 P(B) B. 1 1-P(B) C. P(A) P(B) D. P(A) 1-P(B) Select the correct answer from above options...
asked Nov 16, 2021 in Education by JackTerrance
0 votes
Q: If a resistor Rx is connected between nodes X and Y, Ry between X and Y, Rz between Y and Z to form a delta connection, then after transformation to star, the resistance at node Z is?
    If a resistor Rx is connected between nodes X and Y, Ry between X and Y, Rz between Y and Z to form a ... Questions for GATE EC Exam, Network Theory MCQ (Multiple Choice Questions)...
asked Oct 20, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...