Which lock should be obtained to prevent a concurrent transaction from executing a conﬂicting read, insert or delete operation on the same key value.

Home / Engineering / Database Management System (DBMS) / Question

Mr. Dubey • 51.43K Points
Coach

Q.) Which lock should be obtained to prevent a concurrent transaction from executing a conﬂicting read, insert or delete operation on the same key value.

(A) higher-level lock

(B) lower-level lock

(D) read write

Correct answer : Option (A) - higher-level lock

Discusssion

Related MCQs on Database Management System (DBMS)

Q. The number of distinct relations on a set of 3 elements is

Q. How much locations an 8-bit address code can select in memory?

Q. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process.

Q. Fine-grain threading is considered as a ______ threading?

Q. What is the output of the following program : print 0.1 + 0.2 == 0.3

Q. Which of the following holds the last instruction fetched?

Q. Query tool is meant for_________.

Q. A processor performing fetch or decoding of different instruction during the execution of another instruction is called ______ .

Q. What is the output of the following? def to_upper(k): return k.upper() x = ['ab', 'cd'] print(list(map(to_upper, x)))

Q. Select the diagram that is used to model the vocabulary of a system.