Ask a Question

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.

in Education by
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. (a) Intention lock modes (b) shared and intention-exclusive (SIX) mode (c) Intention-exclusive (IX) mode (d) Intention-shared (IS) mode The question was posed to me in an internship interview. Question is from Multiple Granularity topic in division Concurrency Control of Database Management

1 Answer

0 votes
by
The correct option is (b) shared and intention-exclusive (SIX) mode To explain: 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 ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
    If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive- ... , 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 __________ 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 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: 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: 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: Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called
    Once the lower-level lock is released, the operation cannot be undone by using the old values of updated ... and Undo Operations in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________
    Consider the employee work-team example, and assume that certain employees participate in more than one ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: A _____________ constraint requires that an entity belong to no more than one lower-level entity set.
    A _____________ constraint requires that an entity belong to no more than one lower-level entity set. ... chapter Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: The ______________ hijacking is implemented on the data flow of protocol shared by all web applications.
    The ______________ hijacking is implemented on the data flow of protocol shared by all web applications. (a) ... -Cyber Security:,Cyber Security-Jobs:,Cyber Security Applications...
asked Oct 31, 2021 in Education by JackTerrance
0 votes
Q: Do these insights work on a file-level as well? For instance, would they work when a single file is shared by a user?
    Do these insights work on a file-level as well? For instance, would they work when a single file is shared by a user?...
asked Mar 10, 2021 in Technology by JackTerrance
0 votes
Q: Techniques to Get rid of low level Locking
    I'm wondering, and in need, of strategies that can be applied to reducing low-level locking. However ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 12, 2022 in Education by JackTerrance

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

...