The extent of the database resource that is included with each lock is called the level of

Related MCQs

• 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.
• Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
• 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.
• A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
• Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called
• In                                  of Oracle, the database administrator creates a user account in the database for each user who needs access.
• If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called