Bissoy.com
Doctors Medicines MCQs Q&A

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.

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. Correct Answer Key-value locking

Key-value locking thus provides increased concurrency.

Related Questions

Statement 1: When a node is split during insertion, the middle key is promoted to the parent as well as retained in right half-node. Statement 2: When a key is deleted from the leaf, it is also deleted from the non-leaf nodes of the tree.
In a dicot pot herb, vaseline/vegetable oil was applied on the upper surface of one leaf (Experimental leaf 1) and on the lower surface of another leaf (Experimental leaf 2). Vaseline/Vegetable oil was not applied to the control leaf. The plant was deliberately not watered for several days. Which leaf will dry up last?
Three statements are followed by four conclusions numbered I, II, III and IV. You have to consider these statements to be true, even if they seem to be at variance with commonly known facts, decide which of the given conclusions logically follow(s) from the statements. Statements: 1. No plant is a flower. 2. No flower is a leaf. 3. Some plants are leaf. Conclusions: I. No leaf is a plant. II. No leaf is a flower. III. Some flowers are plants. IV. All leaf are plants.
Consider a weight balanced tree such that, the number of nodes in the left sub tree is at least half and at most twice the number of nodes in the right sub tree. The maximum possible height (number of nodes on the path from the root to the farthest leaf) of such a tree on k nodes can be described as
Post office protocol (POP) is a message access protocol which is used to extract message for client. In this regard, which of the following are true ? (A) POP has two modes, Delete mode and keep (B) In Delete mode, mail is deleted from mail box after each retrival (C) In Delete mode, mail is deleted from mail box before each retrieval (D) In keep mode, mail is deleted before retrival (E) In keep mode, mail remains in mail box after retrival Choose the correct answer from the options given below:
A teacher of Class VII demonstrates the following activity in the class: “A leaf is put in a test tube and spirit is poured over it. Then the test tube is put in a beaker half-filled with water and heated till the leaf is discoloured. The leaf is then taken out and a few drops of iodine are put on it. The leaf turns blue-black in colour.” After this activity, the teacher gives some questions for the assessment of various indicators of learning. Which of the following would assess ‘analysis’?
A teacher puts a leaf in a test tube and puts sprit (alcohol) in it. Now he heats the test tube till all the green colour comes out. Then he takes out the leaf and pour some iodine solution on it.  The students write the following statements in their notebooks. A) The leaf turns blue black in colour  B) The leaf contains starch  Which of the following statements is correct. 
Consider a 13 element hash table for which f(key) = key mod 13 is used with integer keys. Assuming linear probing is used for collision resolution, at which location would the key 103 be inserted, if the keys 661, 182, 24 and 103 are inserted in that order?
In the following question, there are six parts marked S1, S6, P, Q, R and S. The position of S1 and S6 is fixed. Some parts of the sentence have been jumbled up. Rearrange these parts and choose the proper sequence from the given options. S1. Two partridges (quail-like birds) lived in a certain tree in the jungle. While one of them lived on the branches, the other lived inside a hole at the foot of the tree. P. One day, one of them went away with some more partridges in search of food. Q. They became good friends, and they would spend long hours with each other telling each other stories and events of their lives R. In this manner, the partridges spent their time in happiness. S. As was usual, when he did not return back even at sunset, the other partridge started worrying S6. He thought, "He has not done this ever. Why has the partridge not returned home today? Has been trapped by some hunter? Or maybe even killed? I cannot live without him. I am certain there is some reason why he has not returned even at nightfall." 
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;