For the consistency property of database transactions, it requires that the state of a database is consistent before and after each transaction, but the intermediate states of a database during a transaction do not need to be consistent.Question 3Select one:TrueFalse

WHAT IS TRUE ABOUT CONSISTANCY OF DATABASE IN DBMS?Select one:a.Every transaction undergoes a consistent database instance, which is the consistent property of databases.b. In most cases, a database remains either in its previous stable state or in a new stable state following the execution of a transactionc.As a result of integrity constraints, the database remains consistent before and after the transaction.d. ALL OF THE ABOVE

Discuss Consistency and Isolation property of a transaction

2 pointsWhich component of DBMS maintains the consistency of a database when multiple transactions are executed simultaneously on the data?Storage ManagerTransaction Management ComponentConcurrency Control ManagerQuery Planner

Which consistency level is typically achieved in NoSQL databases? Question 7Select one: Immediate consistency Weak consistency Strong consistency Eventual consistency

In a distributed database system, which approach is used to ensure that all copies of a data item are updated simultaneously?Immediate consistencyEventual consistencyQuorum consensusSerializability