transactions

Question 1

what is a transaction

Answer 1

it isa bundle of database operation operated as 1 unit without inteference of other transaction in a multi user databse
consist of recovery and synchronisation

Question 2

explain BOT COMMIT;ABORT

Answer 2

BOT- Begin of transaction
commit-succesful
abort- fehler

Question 3

ATOM explain

Answer 3

Atomicity->Everything or nothing ,
consistency. consitent of the database
isolation-> every transaction has the db for himself no influence of other
durability-> no data loss