A property that ensures only valid or legal transactions that do not violate any user-defined integrity constraints in DBMS technologies is known as ?

A.
Atomicity

B.
Consistency

C.
Isolation

D.
Durability

Explanation:
B: ACID test, which stands for atomicity, consistency, isolation, and durability, is an important DBMS concept. Atomicity is when all the parts of a transactions execution are either all committed or all rolled backdo it all or not at all. Essentially, all changes take eff ect, or none do. Consistency occurs when the database is transformed from one valid state to another valid state. A transaction is allowed only if it follows user-defined integrity constraints. Illegal transactions are not allowed, and if an integrity constraint cannot be satisfied, the transaction is rolled back to its previously valid state and the user is informed that the transaction has failed. Isolation is the process guaranteeing the results of a transaction are invisible to other transactions until the transaction is complete. Durability ensures the results of a completed transaction are permanent and can survive future system and media failures, that is, once they are done, they cannot be undone. This is similar to transaction persistence. Page 249.