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

Related MCQs

• Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
• The situation where the lock waits only for a specified amount of time for another lock to be released is
• A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock.
• In a ____ lock, the DBMS will lock an entire disk page.
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
• The database design prevents some data from being represented due to                
• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• A                  is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
• A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.