Database Questions Bank Online Exam Quiz
Database Questions Bank GK Quiz. Question and Answers related to Database Questions Bank. MCQ (Multiple Choice Questions with answers about Database Questions Bank
Instead of locking index leaf nodes in a two-phase manner, some index concurrency-control schemes use ___________ on individual key values, allowing other key values to be inserted or deleted from the same leaf.
Options
A : B+ tree locking
B : Link level locking
C : Key-value locking
D : Next value locking
The method of access that uses key transformation is called as
Options
A : Direct
B : Hash
C : Random
D : Sequential
In crabbing protocol locking
Options
A : Goes down the tree and back up
B : Goes up the tree and back down
C : Goes down the tree and releases
D : Goes up the tree and releases
How many techniques are available to control concurrency on B+ trees?
Options
A : One
B : Three
C : Four
D : None of the mentioned
The deadlock can be handled by
Options
A : Removing the nodes that are deadlocked
B : Restarting the search after releasing the lock
C : Restarting the search without releasing the lock
D : Resuming the search
In crabbing protocol, the lock obtained on the root node is in _________ mode.
Options
A : Shared
B : Exclusive
C : Read only
D : None of the mentioned
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.
Options
A : Shared
B : Exclusive
C : Read only
D : None of the mentioned
In crabbing protocol to inset or delete a key value the leaf node has to be locked in ___________ mode.
Options
A : Shared
B : Exclusive
C : Read only
D : None of the mentioned
Why do we need concurrency control on B+ trees ?
Options
A : To remove the unwanted data
B : To easily add the index elements
C : To maintain accuracy of index
D : All of the mentioned
B-link tree requires a pointer to its __________ sibling.
Options
A : Upper
B : Lower
C : Right
D : Left
Chemical Engineering Basics - Part 1 more Online Exam Quiz
Database Questions And Answers Encryption And Its Applications