in Education by
If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called (a) Intention lock modes (b) Explicit lock (c) Implicit lock (d) Exclusive lock The question was asked during an internship interview. This interesting question is from Multiple Granularity topic in chapter 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 option is (a) Intention lock modes For explanation: There is an intention mode associated with shared mode, and there is one with an exclusive mode.

Related questions

0 votes
    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
    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
    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
    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
    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
    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
    In B+ tree the node which points to another node is called (a) Leaf node (b) External node (c) ... and Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    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
    Five node splitting operations occurred when an entry is inserted into a B-tree. Then how many nodes are written? a) 14 b) 7 c) 11 d) 5...
asked Dec 23, 2020 in Technology by JackTerrance
0 votes
    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
    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
    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
    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
    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
    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
...