Ask a Question

If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.

in Education by
If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks. (a) Intention lock modes (b) Intention-shared-exclusive mode (c) Intention-exclusive (IX) mode (d) Intention-shared (IS) mode I had been asked this question at a job interview. Enquiry is from Multiple Granularity topic in section 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 (a) Intention lock modes 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 ____________ 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 ______________ 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 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: 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: B-tree of order n is a order-n multiway tree in which each non-root node contains __________
    B-tree of order n is a order-n multiway tree in which each non-root node contains __________ a) at most (n – 1)/2 keys ... ) at least 2n keys d) at least (n – 1)/2 keys...
asked Dec 23, 2020 in Technology 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 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: All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.
    All lock information is managed by a __________ which is responsible for assigning and policing the locks ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Bitmaps can be combined with regular B+-tree indices for relations where a few attribute values are extremely common, and other values also occur, but much less frequently.
    Bitmaps can be combined with regular B+-tree indices for relations where a few attribute values are ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education 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
0 votes
Q: How to scroll to selected node in PrimeNG Tree
    I have a page with PrimeNG tree and an autocomplete field. My requirement is Tree should be expanded to ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 26, 2022 in Education by JackTerrance
0 votes
Q: How to optimize building a tree from a list of the node paths?
    Suppose I am writing a function fromPaths(paths: List[String]): Node to build a tree from a few ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 16, 2022 in Education by JackTerrance
0 votes
Q: Which node type represents the root-node of the DOM tree?
    Which node type represents the root-node of the DOM tree? (a) Document (b) DocumentFragment (c) ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 23, 2021 in Education by JackTerrance

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

...