Transactions possess which of the following properties? Select all that apply.
Explanation
ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions. In the context of databases, a sequence of operations that satisfies the ACID properties and, thus, can be perceived as single logical operation on the data, is called a transaction.
Atomicity means that any given transaction is atomic - it either apply all its modifications to the database ot none of them.
Consistency guarantees that every transaction brings database from one consistent state to another consistent state.
Isolation is a way in which transactions that happen at the same time are handled by the database. There are different approaches towards that called isolation levels. But, as a general rule of thumb, isolation may be treated as follows - transactions that occur at the same time should be performed one after another/
Durability means that once transaction has finished - all the changes it has made to the database are durable (they will be seen from now on).

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Keep exploring
SQL quizzes
Cosmo
Sign Up Now
or Subscribe for future quizzes