Ask a Question

All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.

in Education by
All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions. (a) Scheduler (b) DBMS (c) Lock manager (d) Locking agent The question was asked in semester exam. My question is taken from Lock-Based Protocols in chapter Concurrency Control of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Correct option is (c) Lock manager Easiest explanation - A distributed lock manager (DLM) provides distributed software applications with a means to synchronize their accesses to shared resources.

Related questions

0 votes
Q: Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This is
    Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing ... Management topic in portion Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Can we check locks in database? If so, how can we do this lock check?
    Can we check locks in database? If so, how can we do this lock check?...
asked Nov 9, 2020 in Technology by Editorial Staff
0 votes
Q: In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
    In the __________ phase, the system replays updates of all transactions by scanning the log forward from the ... from Recovery in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Which are the attributes of Bean Managed Transactions?
    Which are the attributes of Bean Managed Transactions?...
asked Nov 7, 2020 in Technology by JackTerrance
0 votes
Q: Which are the attributes of Container Managed Transactions?
    Which are the attributes of Container Managed Transactions?...
asked Nov 7, 2020 in Technology by JackTerrance
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: A lock that allows concurrent transactions to access different rows of the same table is known as a
    A lock that allows concurrent transactions to access different rows of the same table is known as a ( ... Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: What is Bean Managed Transactions?
    What is Bean Managed Transactions?...
asked Nov 7, 2020 in Technology by JackTerrance
0 votes
Q: What is Container Managed Transactions in EJB?
    What is Container Managed Transactions in EJB?...
asked Nov 7, 2020 in Technology by JackTerrance
0 votes
Q: If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
    If a node is locked in __________ explicit locking is being done at a lower level of the tree, but ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions.
    Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions. (1)False (2)True...
asked Apr 22, 2021 in Technology by JackTerrance
0 votes
Q: Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions.
    Consistency of CAP theorem states that all the protocols must be satisfied by the transaction. There can be half-completed transactions....
asked Oct 11, 2020 in Education by anonymous
0 votes
Q: If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.
    If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ... Based Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: A centrally managed solution that protects networks and all their endpoints against threats with the help of various security tools:
    A centrally managed solution that protects networks and all their endpoints against threats with the help of ... Endpoint Protection 3. Endpoint Security 4. Network Security...
asked Oct 24, 2020 by JackTerrance
0 votes
Q: The _________ is one of the brokers and is responsible for maintaining the leader/follower relationship for all the partitions.
    The _________ is one of the brokers and is responsible for maintaining the leader/follower relationship for all the partitions. (1)Master (2)Controller (3)None (4)Main server...
asked Jun 16, 2021 in Technology by JackTerrance

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

...