The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called

Related MCQs

• State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.
• If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:
• 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.
•          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
•                means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• A system is in a              state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
• Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under
• A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.
•                      are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.