Ask a Question

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.

in Education by
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. (a) Shared (b) Exclusive (c) Read only (d) None of the mentioned This question was addressed to me by my college professor while I was bunking the class. This interesting question is from Concurrency in Index Structures topic in division 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
The correct option is (b) Exclusive The best explanation: Crabbing protocol moves in a crab like manner down the index tree.

Related questions

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 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: In crabbing protocol, the lock obtained on the root node is in _________ mode.
    In crabbing protocol, the lock obtained on the root node is in _________ mode. (a) Shared (b) ... in Index Structures in portion 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 ______________ 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: In crabbing protocol locking
    In crabbing protocol locking (a) Goes down the tree and back up (b) Goes up the tree and back ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: How to split 1 key value into 2 keys values
    I'm new to JavaScript. I have the following object: let obj1 = [{ 'id': 1, 'longString': ' ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 21, 2022 in Education by JackTerrance
0 votes
Q: How to split 1 key value into 2 keys values
    I'm new to JavaScript. I have the following object: let obj1 = [{ 'id': 1, 'longString': ' ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 21, 2022 in Education by JackTerrance
0 votes
Q: The coalesce function provides one way to substitute constant values for which values
    The coalesce function provides one way to substitute constant values for which values Select the correct answer from above options...
asked Dec 29, 2021 in Education by JackTerrance
0 votes
Q: If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.
    If an attribute of a composite key is dependent on an attribute of the other composite key, a ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: What is it called where object has its own lifecycle and child object cannot belong to another parent object?
    What is it called where object has its own lifecycle and child object cannot belong to another parent object? ... questions and answers pdf, java interview questions for beginners...
asked Oct 26, 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: An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
    An ____________ consists of a search-key value and pointers to one or more records with that value as ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Easiest way to split string into Key / value
    What's the best way to extract the key and value from a string like this: var myString = 'A1234= ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 9, 2022 in Education by JackTerrance
0 votes
Q: A ____________ is a set of changes done to any program or its associated data designed for updating, fixing, or improving it.
    A ____________ is a set of changes done to any program or its associated data designed for updating, fixing, or ... Security questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 4, 2021 in Education by JackTerrance

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

...