Explore topic-wise MCQs in Database.

This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

Explore topic-wise MCQs in Database.

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.?$

This_validation_scheme_is_called_the___________scheme_since_transactions_execute_optimistically,_assuming_they_will_be_able_to_finish_execution_and_validate_at_the_end.$

The _____________ ensures that any conflicting read and write operations are executed in timestamp order?

____________ denotes the largest timestamp of any transaction that executed write(Q) successfully.

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 ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.

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 an intention mode, explicit locking is done at a lower level of the tree. This is called

In a database the file is contained in ________

In a granularity hierarchy the highest level represents the