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

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

How does a DBMS ensure data integrity and consistency?

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

The four properties of database transactions (i.e., the ACID properties) are atomicity, consistency, integrity, and durability.

Which of the following is not a feature of DBMS?a.Consistency of datab.High Level of Securityc.Single-user Access onlyd.Minimum Duplication and Redundancy of Data