Ask a Question

A lock that allows concurrent transactions to access different rows of the same table is known as a

in Education by
A lock that allows concurrent transactions to access different rows of the same table is known as a (a) Database-level lock (b) Table-level lock (c) Page-level lock (d) Row-level lock The question was asked in an online quiz. The doubt is from Lock-Based Protocols topic in section Concurrency Control of Database Management

1 Answer

0 votes
by
Correct answer is (d) Row-level lock To explain: Locks are used to maintain database consistency.

Related questions

0 votes
Q: The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
    The ____ lock allows concurrent transactions to access the same row as long as they require the use of ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 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: The same information that can be used at different places in different format is known as: *
    The same information that can be used at different places in different format is known as: * Select the correct answer from above options...
asked Dec 10, 2021 in Education by JackTerrance
0 votes
Q: All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.
    All lock information is managed by a __________ which is responsible for assigning and policing the locks ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
    The ___________ policy, allows the system to write modified blocks to disk even if the transactions that ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: A condition that occurs when two transactions wait for each other to unlock data is known as a(n)
    A condition that occurs when two transactions wait for each other to unlock data is known as a(n ... from Multiversion Schemes in chapter Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: who allows two or more users to work on single computer at same or different time
    who allows two or more users to work on single computer at same or different time Select the correct answer from above options...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
Q: The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
    The ______ clause allows us to select only those rows in the result relation of the ____ clause that ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Explain Which of this access specifies can be used for a class so that its members can be accessed by a different class in the same package?
    Which of this access specifies can be used for a class so that its members can be accessed by a different class ... & Packages of Java Select the correct answer from above options...
asked Feb 23, 2022 in Education by JackTerrance
0 votes
Q: Which of this access specifies can be used for a class so that its members can be accessed by a different class in the same package?
    Which of this access specifies can be used for a class so that its members can be accessed by a ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 24, 2021 in Education by JackTerrance
0 votes
Q: The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as
    The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving ... Storage topic in portion Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: _____________ is a powerful database software that allows us to create, manage and process data in the form of a table
    _____________ is a powerful database software that allows us to create, manage and process data in the form of a table Select the correct answer from above options...
asked Dec 20, 2021 in Education by JackTerrance
0 votes
Q: get rows that have the same value column
    I'm trying to select rows that have the same column values using BigQuery on Githubs public data. I' ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 6, 2022 in Education by JackTerrance
0 votes
Q: _________ allows user to ins two operating system on same computer
    _________ allows user to ins two operating system on same computer Select the correct answer from above options...
asked Dec 20, 2021 in Education by JackTerrance
0 votes
Q: Choose the data model which allows applications to store related pieces of information in the same database record.
    Choose the data model which allows applications to store related pieces of information in the same database record. (1) ... )All the Options (3)Embedded Model (4)Reference Model...
asked May 23, 2021 in Technology by JackTerrance

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

...