Ask a Question

In crabbing protocol to inset or delete a key value the leaf node has to be locked in ___________ mode.

in Education by
In crabbing protocol to inset or delete a key value the leaf node has to be locked in ___________ mode. (a) Shared (b) Exclusive (c) Read only (d) None of the mentioned I had been asked this question during an online interview. This interesting question is from Concurrency in Index Structures topic in section Concurrency Control of Database Management

1 Answer

0 votes
by
Correct answer is (b) Exclusive The best I can explain: Crabbing protocol moves in a crab like manner down the index tree.

Related questions

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, 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 ____________ 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 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: Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
    Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 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: Connection authentication is offered for ensuring that the remote host has the likely Internet Protocol (IP) ___________ & _________
    Connection authentication is offered for ensuring that the remote host has the likely Internet Protocol (IP) ___________ & ... questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 3, 2021 in Education by JackTerrance
0 votes
Q: An example of Key-Value datastore is ___________.
    An example of Key-Value datastore is ___________. (1)MongoDB (2)Neo4j (3)DynamoDB (4)BigTable...
asked Apr 23, 2021 in Technology by JackTerrance
0 votes
Q: In Riak Key Value datastore, the Replication Factor 'N' indicates ___________.
    In Riak Key Value datastore, the Replication Factor 'N' indicates ___________. (1)Number of Write Operations (2)Number of Data Copies to be maintained across nodes...
asked Apr 23, 2021 in Technology by JackTerrance
0 votes
Q: to edit the interactive mode which key combination should be press
    to edit the interactive mode which key combination should be press Select the correct answer from above options...
asked Dec 21, 2021 in Education by JackTerrance
0 votes
Q: Which type of Key-value datastore DB has its key and value sorted?
    Which type of Key-value datastore DB has its key and value sorted? (1)Solid-State Key-Value datastore ( ... Ordered Key-Value datastore (4)Eventually Consistent Key-Value datastore...
asked Apr 23, 2021 in Technology by JackTerrance
0 votes
Q: restapi using mongoose and node.js on post,put, and delete
    so i'm reviewing and practicing making rest api with node mongoose and express. I'm having problem making ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 14, 2022 in Education by JackTerrance

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

...