Ask a Question

A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a

in Education by
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) Database-level lock (b) Table-level lock (c) Page-level lock (d) Row-level lock I got this question during an interview. This interesting question is from Multiversion Schemes in section Concurrency Control of Database Management

1 Answer

0 votes
by
Right answer is (a) Database-level lock To explain: Data base-level lock prevents the use of any tables in the data base from one transaction while another transaction is being processed.

Related questions

0 votes
Q: The database design prevents some data from being represented due to _______
    The database design prevents some data from being represented due to _______ (a) Deletion anomalies (b) ... Querying Database topic in chapter Transactions of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.
    If database modifications occur while the transaction is still active, the transaction is said to use the ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: what option can bne used to import only some of the table from a database while using the --import-all-tables parameter?
    what option can bne used to import only some of the table from a database while using the --import-all-tables parameter? ... without-tables C - --forgo-tables D - --exclude-tables...
asked Jan 13, 2021 in Technology by JackTerrance
0 votes
Q: The extent of the database resource that is included with each lock is called the level of
    The extent of the database resource that is included with each lock is called the level of (a) Impact ... , 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 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: The database design that consists of multiple tables that are linked together through matching data stored in each table is called
    The database design that consists of multiple tables that are linked together through matching data stored in ... Hashing in division Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: How do you lock tables in SQL Server 2005, and should I even do it?
    This one will take some explaining. What I've done is create a specific custom message queue in SQL ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 16, 2022 in Education by JackTerrance
0 votes
Q: Bag I contains 3 red and 4 black balls while another Bag II contains 5 red and 6 black balls. One ball is drawn at random from one of the bags and it
    Bag I contains 3 red and 4 black balls while another Bag II contains 5 red and 6 black balls. One ball is ... was drawn from Bag II. Select the correct answer from above options...
asked Nov 13, 2021 in Education by JackTerrance
0 votes
Q: Suppose you have some subset of codes with you while working with the SVN and you need to move them from one SVN repo simply to another along with their history, how this can be done?
    Suppose you have some subset of codes with you while working with the SVN and you need to move them from one SVN repo ... to another along with their history, how this can be done?...
asked Feb 18, 2021 in Technology by JackTerrance
0 votes
Q: If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.
    If a transaction does not modify the database until it has committed, it is said to use the ___________ ... from Recovery topic in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Explain What will happen if two thread of the same priority are called to be processed simultaneously?
    What will happen if two thread of the same priority are called to be processed simultaneously? (a) Anyone ... Multithreading of Java Select the correct answer from above options...
asked Mar 1, 2022 in Education by JackTerrance
0 votes
Q: The situation where the lock waits only for a specified amount of time for another lock to be released is
    The situation where the lock waits only for a specified amount of time for another lock to be released is ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance

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

...