SQL Language Instructions used to perform a group of sql instructions as a together in order for them to keep their atomicity (ACID properties). Most common is BEGIN TRANSACTION, followed by a set of instructions (INSERT, UPDATE, etc.), ending with either COMMIT (success) or ROLLBACK if there was a problem for the database to get back to a consistent state.
data transaction languagedata transaction languagedata transaction language data transaction languagedata transaction language
Data manipulation language(DML) data Defenition language(DDL) data control Language(DCL) Transaction Control
1.The data definition facility or data definition language (DDL). 2.The data manipulation facility or data manipulation language (DML). 3.The data query facility or data query language [DQL]. 4.The data control facility or data control language [DCL]. 5.The transaction control facility or data control language [TCL].
Like transaction in banks there are transactions in a database system too like deleting data is also a transaction. Transaction can be recovered using rollback and save point.
once one transaction is accessing the data, no other transaction is made to modify the data
once one transaction is accessing the data, no other transaction is made to modify the data
data entry
machine level language
Data Definition Language (DDL): Used to define and modify the structure of database objects like tables, indexes, and views. Data Manipulation Language (DML): Used to query and manipulate data in tables, such as SELECT, INSERT, UPDATE, and DELETE. Data Control Language (DCL): Used to control access to data, like granting and revoking permissions. Transaction Control Language (TCL): Used to manage transactions within a database, like committing or rolling back changes.
·A nested transaction is a transaction that is logically decomposed into a hierarchy of sub transaction. A distributed transaction is logically a flat, indivisible transaction that operates on distributed data.
is data different from information?
transaction data