0
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.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
Define dtl in sql?
data transaction languagedata transaction languagedata transaction language data transaction languagedata transaction language
What are the elements of SQL?
Data manipulation language(DML) data Defenition language(DDL) data control Language(DCL) Transaction Control
DBMS facilities required for Recovery and back up?
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].
What can you do with SQL?
SQL is used to communicate with and manage databases. You can use it to retrieve, insert, update, and delete data from databases. It is also used for creating tables, views, functions, and stored procedures.
What is a transaction in a data base system?
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.
What is lock-base protocols?
once one transaction is accessing the data, no other transaction is made to modify the data
What is lock based protocols?
once one transaction is accessing the data, no other transaction is made to modify the data
What is entering transaction data on a form called?
data entry
Why database integrity?
Database integrity ensures that data stored in the database is accurate and reliable. It helps prevent data corruption, inconsistencies, and errors by enforcing rules and constraints. Maintaining database integrity ensures that the information remains trustworthy and can be relied upon for decision-making processes.
In which language we don't need transaction?
machine level language
Difference between nested and distributed transaction?
·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.
Does a transaction processing information produce information or data?
is data different from information?
