Which of the following are introduced to reduce the overheads caused b – McqOptions

MCQOPTIONS

1.	Which of the following are introduced to reduce the overheads caused by the log-based recovery?
A.	Checkpoints
B.	Indices
C.	Deadlocks
D.	Locks
Answer» B. Indices

Discussion

No Comment Found

Related MCQs

THE______LOCK_ALLOWS_CONCURRENT_TRANSACTIONS_TO_ACCESS_THE_SAME_ROW_AS_LONG_AS_THEY_REQUIRE_THE_USE_OF_DIFFERENT_FIELDS_WITHIN_THAT_ROW.?$
Which_of_the_following_is_a_procedure_for_acquiring_the_necessary_locks_for_a_transaction_where_all_necessary_locks_are_acquired_before_any_are_released?$
All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions?
Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other
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.$
Which of the following is the block that is not permitted to be written back to the disk?
Which of the following protocols ensures conflict serializability and safety from deadlocks?
Which of the following are introduced to reduce the overheads caused by the log-based recovery?
A lock that allows concurrent transactions to access different rows of the same table is known as a
In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?