| |
|
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.
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.
SQL Queries
SQL
Create Table
DDL, Create, Alter, Drop commands
DML, Select, Insert, Update, Delete
Create Database
ACID Rules
Dual Table
NULL
Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
Table, View and a Synonym?
Execute
Function
Stored Procedure
Syntax Stored Proc
Stored Procedure Vs. Function
| |