What are ACID Rules of transaction in a database? Atomicity, Consistency, Isolation, Durability
The ACID rules of transaction in any database assure the reliability of data in all transactions in the database.
DDL, Create, Alter, Drop commands
DML, Select, Insert, Update, Delete
Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
Table, View and a Synonym?
Syntax Stored Proc
Stored Procedure Vs. Function
Atomicity - this rule states that either the complete transaction takes place, or none. Even if
a part of a transaction fails to work, the complete transaction will fail.
Consistency - this rule ensures that the database is stable, before and after the transaction, even
if a transaction fails.
Isolation - this rule states that when a process is going on in a transaction, the data remains in isolation
of other entities in the database.
Durability - this rule states that when a transaction completes successfully, it remains in stable
state and is persisted in the database.