Flashcards
Transactions
Cards in this deck (9)
- 1What does ACID stand for?ATOMIC
CONSISTENT
ISOLATED
DURABLE - 2Explain atomiceither the whole transaction is executed, or none is.
- 3Explain consistentdatabase constraints are preserved.
- 4Explain isolatedappears to the user as if only one
process executes at a time. - 5Explain durableeffects of a transaction do not get lost if the system crashes.
- 6What is ROLLBACK? Give en example of what can cause a ROLLBACK. What effect does ROLLBACK have on the database?ROLLBACK causes the transaction to end, but by aborting.
Failures like division by 0 can also cause rollback, even if the programmer does not request it.
No effects on the database. - 7What does JDBC stand for?Java Database Connectivity
- 8What problems does Logging prevent?Logging only prevents problems related to de-synchronization with main memory.
- 9How many isolation levels are there in SQL?SQL defines four isolation levels = choices about what interactions are allowed by transactions that execute at about the same time.
Information
- Description
- 1 Database Flashcards on Transactions, created by linneamd on 15/03/2016.
- Created by
- linneamd
- Views
- 2
- Rating