A lock that allows concurrent transactions to access different rows of – McqOptions

MCQOPTIONS

1.	A lock that allows concurrent transactions to access different rows of the same table is known as a
A.	Field-level lock
B.	Row-level lock
C.	Table-level lock
D.	Database-level lock
Answer» B. Row-level lock

Discussion

No Comment Found

Related MCQs

Who detects the failure of the system and restore the database to consistent state ?
Which phage always carries a small piece of E.coli genome?
Which of the following are functions of Database Manager ? 1. Interacting with File Manager 2. Creating Queries to Access data 3. Security Enforcement 4. Database Definition and Schema Generation
Transaction management ensures ____________ and __________ properties.
___________ is an interface between low level database and application program.
A transaction may not always complete its execution successfully. Such a transaction is termed
Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?
What are the Svedberg values for the subunits of the 70S ribosomes of E. colli?
When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is
The deadlock state can be changed back to stable state by using _____________ statement.