Ask a Question

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.

in Education by
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. (a) Explicit lock in exclusive mode (b) Implicit lock in shared mode (c) Explicit lock in shared mode (d) Implicit lock in exclusive mode I have been asked this question by my college professor while I was bunking the class. I need to ask this question from Lock-Based Protocols topic in section Concurrency Control of Database Management

1 Answer

0 votes
by
Right answer is (d) Implicit lock in exclusive mode Best explanation: If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an implicit lock in exclusive mode on all the records belonging to that file.

Related questions

0 votes
Q: If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
    If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive- ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If a node is locked in ______________ the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.
    If a node is locked in ______________ the subtree rooted by that node is locked explicitly in shared ... Granularity topic in division Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: 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
    When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti). This is
    When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The __________ requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
    The __________ requires that each transaction Ti executes in two or three different phases in its lifetime ... topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: When a transaction Ti attempts to update a data item, it requests a _________ on that data item.
    When a transaction Ti attempts to update a data item, it requests a _________ on that data item. ... Snapshot Isolation topic in chapter Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
    If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. ... Answers, 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: 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: A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
    A lock that prevents the use of any tables in the database from one transaction while another ... Multiversion Schemes in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: The probability of happening of an event A is 0.5 and that of B is 0.3. If A and B are mutually exclusive events, then the probability of neither A no
    The probability of happening of an event A is 0.5 and that of B is 0.3. If A and B are mutually exclusive ... 0.7 D. none of these Select the correct answer from above options...
asked Nov 16, 2021 in Education by JackTerrance
0 votes
Q: The probability of happening of an event A is 0.5 and that of B is 0.3. If A and B are mutually exclusive events, then the probability of neither A no
    The probability of happening of an event A is 0.5 and that of B is 0.3. If A and B are mutually exclusive ... neither A nor B is .. Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance
0 votes
Q: A combination lock on a suitcase has 3 wheels, each labelled with nine digits from 1 to 9. If an opening combination is a particular sequence of three
    A combination lock on a suitcase has 3 wheels, each labelled with nine digits from 1 to 9. If an opening ... the right combination ? Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance

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

...